home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload Trio 2
/
Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO
/
dir42
/
bbdo43.zip
/
DOALL.DOC
< prev
next >
Wrap
Text File
|
1994-04-06
|
141KB
|
3,109 lines
April 6, 1994
=================================================================
DOALL
=================================================================
User's Guide
Most questions can be answered by reading this User's Guide
COPYRIGHT 1994 B&B Systems
B&B SYSTEMS
P.O. Box 171 627 Madison
Waukesha, Wisconsin 53187
Voice:414-544-5988 (9:00-5:00 CDT) Data/Fax 414-548-9034 (24hrs)
Data line is P.C. Manager, B&B system's
Bulletin Board for Files+Tips+Support+On-Line Ordering
Compuserve:70265,410
LIMITED SHAREWARE VERSIONS OF THIS SOFTWARE ARE DISTRIBUTED
FREELY. NO PRICE OR CONSIDERATION SHOULD BE CHARGED FOR THIS
SOFTWARE, UNLESS IT IS FOR THE COST OF REGISTRATION WITH B&B
SYSTEMS. COMMERCIAL DISTRIBUTORS MAY DISTRIBUTE THIS SOFTWARE,
BUT THEY SHOULD NOT CHARGE FOR THIS SOFTWARE, ALTHOUGH THEY
COMMONLY COVER THEIR COSTS WITH A "DISTRIBUTION" FEE. FILES AND
PROGRAMS ON THIS DISK SHOULD NOT BE MODIFIED, NOR SOLD AS PART OF
SOME OTHER INCLUSIVE SOFTWARE PACKAGE. REMEMBER, DEMO VERSIONS
LIMIT THE NUMBER OF RECORDS YOU CAN ADD.
B&B DOALL User's Guide 2
BBDO.ZIP CONTAINS THE FOXPRO RUNTIME FILES. IF YOU ALREADY HAVE
THEM, BBDOS.ZIP IS SMALLER.
*------------------- What is DOALL ??? -------------------------*
| |
| The Front End for any dBase/FoxPro/Alpha4/Compatible |
| data base - The complete easy-to-use system |
| for MAILINGS, TELEMARKETING, SALES LEADS, OFFICE RECORDS, |
| LETTERS, REPORTS, LABELS, CONTACTS, CUSTOMERS, ETC. |
*---------------------------------------------------------------*
* FASTER - Uses SQL technology for counting records, producing
labels and reports. Produces reports on 40,000 record file in
less than a minute. ADVANTAGE? You don't have to use SQL
commands, SQL is called automatically using regular menu
selections!
* Full Adding/Editing
* Produce reports/labels/letters in any sort/for any records
* A data converter. Import spreadsheets/Word Processors,
change data
* Displays memo field/notes while browsing thru individual
records.
* Search any field, value within field - Replace with any new
value.
* Search memo type fields
* Change color schemes
* Use the SAME engine for accessing files
(Minimizes learning time)
* Move records from one system, find Duplicates and move
back again
* Change capitalization, replace one field with another value
* Control printer functions for all printers
* Add, Change, or Delete any fields yourself
* Modify "help" files
* Make custom screens for data validation when adding records.
* When adding records, have any data repeated
* Make "Lookup" files for any/all fields in the data file
* Automatically calls your own custom.prg program
* Put US Postal Service barcodes on labels
* Use "Lookup" <F2> function in any field in Browse screen,
say for ZIP CODES. If <Enter>, information from all "like"
fields in the ZIP "Lookup" file will be transferred to main
data file.
* All indexes are updated continuously, thus, if you commonly
use a custom sort, it will not have to be recreated each
time you use your system.
* Browse screen allows users with modems to dial phone numbers,
then enter your notes about the phone call
- automatically enter date, topic, update callback date.
* Create multiple labels of one record. Ability to "nest"
letters within other letters.
* If you have FoxPro, you can create/modify/run faster SQL-
Query by Example reports, labels and browses
* Capability to add custom EDIT SCREENS and ADD SCREENS
* If CALLBACK date field exists, pending callbacks will pop up
* When producing letters:
B&B DOALL User's Guide 3
- Automatic update of action codes and dates when producing
letters if field named ACTION1, ACTDATE1, ACTION2, ACTDATE2
exist (name of letter/date is inserted into ACTION1/ACTDATE1),
other values moved
- Letters requiring special attention - use a field called
"BELLRINGER" to pause the printer and ring the bell, eg.
insert "ADD CATALOG"
- Reports allow printing of follow-up lists to Sales Reps/Local
Offices and/or Distributors.
* Support data exchanges TO/FROM REMOTE OFFICES (field personnel
- sales reps) and CENTRAL OFFICE for overnight upload/download.
* Get record COUNTS for selected records
* Partition Browse screen so you can still see the NAME or
COMPANY on the left side of the screen while moving around to
other data.
DOALL will give you comprehensive access to your Dbaseiii,
Dbaseiv, FoxBase, FoxPro, AlphaFour or compatible file WITHOUT
HAVING TO WORRY ABOUT FORMATS, SETUPS, LEARNING A NEW SYSTEM EACH
TIME YOU WANT TO USE A DATA FILE. (Note: FoxPro2.0 data files
have unique MEMO fields compared to dBase).
====================
DISTRIBUTION POLICY
====================
DEMO versions of Systems produced by B&B Systems of Waukesha are
commonly distributed through the 'Shareware' concept.
SHAREWARE Software means that you can try software prior to
purchasing it. It is based on the premise that 1) you should be
able to try software before you purchase it, 2) sharing of
information is to be encouraged, and 3) those users who decide to
use such software have an obligation to support the Shareware
authors so that Shareware development can continue.
Shareware versions of this software have limitations, usually
number of records or time period, and are distributed freely. We
encourage others to distribute these demo versions. Should you
decide to purchase, you can ONLY PURCHASE through B&B systems.
Some companies will charge you for a disk copying service, but
they are NOT ALLOWED TO SELL B&B SYSTEMS. They are basically a
"disk copying service". Files and programs on this disk should
not be modified, nor sold as part of some other software package.
If you decide to use this software, please register. It is the
only way QUALITY software will continue to be available.
==============================================
WE ENCOURAGE YOU TO DISTRIBUTE SHAREWARE DEMOS
==============================================
Although B&B Systems encourages you to copy and distribute
limited edition Demo versions, this is not public domain
software. This program is copyrighted. Also, should you decide
to register your system, remember that sharing registered copies
with others is not just illegal, but registrations from all users
B&B DOALL User's Guide 4
will help ensure that YOUR system continues to IMPROVE and GROW.
INSTALLATION
============
If you haven't made a BACKUP copy recently, do it now.
1) If you don't already have one, Make a "DOALL" directory: At
C:\>, enter MD DOALL, then CD\DOALL (or use the INSTALL.BAT file
included)
2) Copy BBDO.EXE to the DOALL directory, C:\DOALL>COPY A:*.*
3) Enter BBDO, and the individual files will be extracted, and
you will be asked some setup questions that are stored in the
file config.mem.
4) See Network section for setting up workstations. Setup your
file server first. Also, for Peer to Peer networks like
Lantastic, Net Lite, you may need to assign "read only"
attributes to the "executable" type files at the DOS level.
5) Startup Syntax: DOALL <name of .DBF file>
To start your system, enter DOALL to answer set-up questions, and
get to main menu. Or, you can start your system to automatically
use a file by entering DOALL <dbffilename>. (dbffilename) is
the file name of any Dbase/FoxPro/Clipper/Alpha Four file.
Upon startup, DOALL will create a compound index file
automatically, allowing you to select any sort quickly. This may
take some time, depending on the size of your data file. Note:
you can turn off the automatic creation of the .cdx file with the
Environmental Variable SET CDX=OFF discussed later.
TIP: If you have three major files that you commonly access, you
can put the following entries into your "menu" to automatically
call the right file:
Menu Description: CUSTOMER FILE Command: DOALL customer
Menu Description: VENDOR FILE Command: DOALL vendor
Menu Description: VEHICLE FILE Command: DOALL vehicle
Any errors will create a file called error.txt. B&B Systems can
use this file to resolve problems.
WINDOWS TIP: You can automatically open the same data file each
time you run DOALL by editing DOALL's "properties". Select the
FILE menu in the Program Manager and select the "properties"
option. This will allow you to edit the Windows command line.
On that line, after C:\DOALL, enter the name of your file, ie,
D:\WORK\WORKFILE.DBF.
CAUTION-1: DON'T ACCESS multiple .DBF files that start with the
same 1st 4 characters. (rename some of your .DBF files) The
reason is that many DOALL support files are created named:
????.MEM and if you have two files called, say, MASTER1.DBF and
MASTER2.DBF, the sort file MASTSORT.MEM file will be used as the
B&B DOALL User's Guide 5
sort definitions for BOTH files.
CAUTION-2: You will get an error at startup if you try opening a
.dbf file with a name beginning with a number. Just rename the
desired file with at least one character at the beginning.
DOS ENVIRONMENTAL VARIABLES
===========================
You can control some attributes of DOALL by setting some DOS
values in your autoexec.bat. Insert a line like: SET CDX=OFF,
and if the value of CDX is checked it will be equal to OFF.
You can control whether the master .CDX (index) file is created
when missing. This is not recommended unless you have a specific
reason for it: SET CDX=OFF.
INSTALLING SEPARATE B&B NETWORK FILES ON WORKSTATIONS/SERVER
(allows each workstation to have different screen setups, etc.)
===============================================================
You can install your B&B System on the file server and have all
workstations access your program files from the server.
BUT IF YOU ONLY HAVE ONE CONFIG.FP and FOXUSER.DBF FILE AND THEY
ARE ON YOUR SERVER, THE FOXUSER.DBF AND FOXUSER.FPT NEED TO BE
MADE "READ-ONLY" IN ORDER TO BE SHAREABLE. AND IF THEY ARE
"READ-ONLY", YOU CAN'T SAVE CHANGES TO YOUR browse screen, like
split screens, field order, display length.
To use the network option that installs individual setup files
for you, install the system and run it on the network drive, say
F:. Upon first time use, you will be asked if you wish the
network setup. Then run your networked system from the
workstation(s) and select Network setup from the setup menu. This
is what you will accomplish each time:
------------------------------------------------------------
1.Define a location for each machine's separate CONFIG.FP file.
2.Define a location for each machine's separate FOXUSER.DBF/FPT
3.Define locations for various "working" directories.
After these values are filled-in, the system will:
--------------------------------------------------
1. Change EACH machine's autoexec.bat so that the location of
EACH MACHINE'S CONFIG.FP file is identified with the line:
SET FOXPROCFG= <C:DIRECTORY>\CONFIG.FP
2. Copy the file CONFIG.DEF to <new location>\CONFIG.FP
3. Write the "working" directory names for EDITWORK, SORTWORK,
OVERLAY, RESOURCE and PROGWORK onto the tail end of the new
CONFIG.FP file.
4. Copies the files DEFUSER.DBF/FPT to <new location>\FOXUSER
(if any of these steps are not accomplished properly, you can
copy these files manually and/or edit config.fp)
This means that when you re-boot after installation, the SET
FOXPROCFG= variable will point to the location of the CONFIG.FP,
B&B DOALL User's Guide 6
and the CONFIG.FP will point to the FOXUSER resource file, and
all of the temporary work directories. WARNING: If you ever
delete directories that are referenced in config.fp, your system
may not load - CANNOT CREATE PROGRAM FILES. So that you don't
inadvertently delete a directory, you could pick the same
directory for the workstation files and the temporary work
directories so that there is at least one file in the directory
to avoid removal (ie. C:\DOALL>).
The CONFIG.FP file is a FoxPro command file that contains startup
values specific for each workstation. Unless you are familiar
with these commands, or have specific needs to customize, you can
leave the default .FP file alone. The FOXUSER file stores
settings, browse window definitions, etc.
NETWORK - GENERAL
=================
On peer to peer networks (ie. Lantastic, Novell Lite), you may
need to use DOS's ATTRIB command to assign the read-only
attribute to 1) the FOXUSER.* files plus 2) any "executable" type
files on your server. These are any .EXE files, FOXPRO.ESO,
FOXPRO.ESL, .COM, .FXP and .SPX files.
Example: C:\DOS\ATTRIB +R FOXPRO.ESO
Also, if you intend to use the F2 Lookup file features and you DO
NOT Intend to Edit the lookup file often, you can assign read
only attributes to the <lookupfile>.dbf and .cdx files to speed
up access to these files.
Also, if you load the operating system SHARE program, make sure
that the values for space reserved for file locking and the
designation for the amount of files that can be locked at one
time are sufficient, such as: SHARE /F:5120 /L:500.
Network versions of B&B Systems work on any LAN that supports
standard protocols of DOS versions 3.1 and greater (ie. Interrupt
21 data locking). B&B Systems are NetBios compatible, and will
support any number of workstations. Networks supported: NOVELL;
3COM; 3+; 10NET(v 4.0); PC-NET; PC-LAN; LANTASTIC; BANYAN;
INVISIBLE; SIMPLENET(v 3.0).
MEMORY ISSUES
=============
If using DOS5.0's DEVICE=EMM386.EXE in your config.sys, and
NOEMS appears in the command line, try your system without this
command. NOEMS says " no expanded memory" and turns off the
demand pager. You can also try to specifically allocate a
portion of the memory as expanded by including the command RAM
and the number of kilobytes of Expanded Memory, such as
DEVICE=EMM386.EXE RAM 3072). YOU SHOULD HAVE A MINIMUM OF 2M of
EMS, and at least 2 Megabytes of hard drive storage.
B&B DOALL User's Guide 7
1. REGULAR EXPANDED MEMORY VERSION - B&B Systems are normally
distributed using the Standard FoxPro which does NOT USE Extended
Memory. Make as much Expanded Memory available as possible. To
make Extended Memory act like Expanded, use a memory manager that
provides the standard LIM4.0 interface. If you have an older
memory manager, and your system behaves strangely, add EMS64=OFF
to your config.fp file to avoiding using the first 64K of
expanded.
If using QEMM, 386MAX, or DOS5.0's EMM386, make sure these
managers define memory as Expanded.
2. EXTENDED MEMORY VERSION - If you have enough extended memory
(at least 2m, 1.5m free), a 386 or greater machine, and would
like more performance, ask us for the Extended version of your
B&B system.)
If you get an error regarding "Cannot locate desired version ..."
for Regular version it means you need more Expanded memory.
Eliminate NOEMS statement in EMM386 line. For Extended version,
you need more Extended Memory.
RUNTIME FILES
=============
B&B Systems normally come with the standard (expanded) FoxPro
runtime files. Files for DOS are called FOXPRO.ESO and
FOXPRO.ESL (For WINDOWS, the runtime file is FOXW2500.ESL).
Runtime files are simply the basic/low-level files that supplies
all of the basic FoxPro functions, while the .EXE file is the
custom system that uses these files.
These "runtime" files are free and available on B&B's Bulletin
Board (see data number above if you have a modem and would like
to download these files). If you want to use the Extended
runtime file, YOU ALSO NEED TO GET the Extended version of your
B&B System .EXE file from B&B Systems in order for your system to
take full advantage of Extended memory.
When FoxPro supports Unix and MacIntosh, B&B will also support
it, allowing portability between operating systems.
REQUIRED EQUIPMENT for WINDOWS
==============================
- 80386SX or greater processor
- Mouse
- 6MB RAM
- MS-DOS 3.1 or greater
- Windows 3.1 running in 386 enhanced mode
- If network, network software that supports a NETBIOS.
WINDOWS TIP: If you run your B&B Systems under windows and your
data entry boxes are white on a white background, and you'd like
to see the data entry boxes in a different color, chose Control
Panel to access your Windows COLOR options. We have found
B&B DOALL User's Guide 8
selecting the color set:EMERALD CITY gives nice screen colors.
WINDOWS TIP: Since the DOS version of all B&B Systems are mouse
compatible, you can easily use the DOS versions in the Window
environment. To make your B&B application selectable from
Windows and add an icon, just select FILE/NEW from the Program
Manager, and add a new item with a NAME for the application, the
Command that the runs it (ie. DOALL, CNG, etc.), and the
directory it resides in (ie. C:\DOALL, D:\CNG, etc.). Remember,
if you get unpredictable results, you could be running short of
memory. Try running outside of windows. If you get different
results, you don't have enough memory left with windows resident
in memory. If you know how to use .PIF files, you can define
custom memory requirements for your B&B system.
CONFIG.SYS FILE
===============
Your system's config.sys file will be checked for the recommended
line: FILES=99. If the value is less, you will be warned to
change this value. For Novell Networks, insure that
FILEHANDLES=99 in the NET.CFG or SHELL.CFG.
IF YOU HAVE FOXPRO
==================
If you have FoxPro, you can operate your B&B System several
different ways, depending on whether you wish to take advantage
of some FoxPro features, not available in the standalone B&B
System.
Options:
1. Standalone - Start your B&B System normally, by entering your
<B&B System name> at the DOS prompt (or, in Windows clicking on
the icon). Your system will operate using the FoxPro runtime
files:FOXR.EXE, FOXPROL.ESO, FOXPROL.ESL.
2. Run Within FoxPro - Start your system within FoxPro by issuing
FOXPRO <B&B system name>. (Note: substitute FOXPROL if you have
the LAN/Network version, or in Windows, run FoxPro and when the
command window is displayed, enter DO <B&B System name>). Please
be sure that the B&B system you have is the same as the FoxPro
version. For example, your B&B System should be the DOS version
if you have FOXPRO for DOS.
Option 2 provides access to SQL menus, and handles some functions
automatically for you. Some B&B Systems will ask that you
compile a .PRG file (to make an .FXP file). This is no longer
applicable because .PRGs will be compiled for you. An example of
this process is when you are using a data base file and adding a
record for the first time in B&B's DOALL. A window will inform
you that an "add screen" file, called <data file name>.PRG has
been newly created and in order to use the extra features that
you can insert in this file such as: data validation or file
B&B DOALL User's Guide 9
lookups (see sample.prg for an example), you need to compile it.
Well, you can edit this .prg file to add those features, similar
to the sample.prg file, and FoxPro will compile it for you the
next time it is called.
DEMO
====
If you are using a DEMO version, you will see a registration
reminder. The Demo is only good for a limited period of time.
You have 365 days upon first installing demos to determine if it
will do the job for you.
CREATING A NEW FILE
===================
If you enter DOALL <filename> and <filename> is a non-existent
file, you will have the option of creating that file. Remember
that when you create a file you will be defining each field
within that file by assigning a name, type (character, numeric,
date, memo, logical) and length. Commonly you should use
"character" type fields, even if the fields commonly contain
numbers such as zip codes. You normally would use numeric type
fields for fields that may require "totalling". Date type fields
provides the proper format for dates (When SET CENTURY=OFF in the
config.fp file, the year is shown as "93" not "1993"). Memo type
fields allow unlimited text to be stored in them and they can be
edited by pressing CTRL-PgDn when the cursor is on that field.
Logical fields allow only True/False or Yes/No entries (T/F,
Y/N).
When you create new data base files, a .DBF is created, as well
as an index file .CDX, and an .FPT file if a MEMO field is used.
(a .TBK file is a backup/prior version of an .FPT file).
GENERAL
=======
To help in navigating through this system, remember these simple
rules: A mouse is helpful to pick options, such as menu options.
From the keyboard, use the <ALT> key, then cursor, to pick menu
options from the top menu. <TAB> is useful to go from option to
option. If you get stuck, <CTRL-W> commonly SAVES work, and
<CTRL>-Q ABANDONS work, <ESC> works similar to CTRL-Q and works
well in menus.
To help understand the system, let's start by doing what you'll
be doing most - looking at records. Selecting Browse/Edit from
the main menu. As you get used to the system, you will normally
just <Enter> twice to select the default for the next two
options, SORT and SELECT. This is a quick way to look at your
records. But, there will be times when you will want a
particular sort, say last name, or to select particular records,
such as last name='SMITH'. Just use the cursor keys to pick the
SORT and SELECTION you want.
WHICH SORT ?? (FLEXI-SORT)
B&B DOALL User's Guide 10
==========================
When you first use your system, like browsing records, you'll
notice that there will be a screen asking for your desired sort.
Each of the fields from your data base will be shown. If you
have a field called COMPANY, you will automatically be able to
select the COMPANY sort WITHOUT having define it or wait to have
an index prepared.
Technical Note: The first time you use your system, an index or
sort file will be created if none is found. A sort for each
field in your file is prepared and combined into one SORT file
with the same name as your data base file, but with a .CDX
extension. All of the sort definitions are maintained in the
.CDX file and are kept current when you add/delete/change
records. If you do not use some of your sort options, and you
delete them, you can reinstate the .CDX file to its original
state (a sort for all fields) by deleting your main .CDX file.
If your main file is customer.dbf, delete customer.cdx.
Example: selecting three fields STATE+ZIP+LASTNAME will produce a
sort Last Name sorted WITHIN Zip Code sorted WITHIN State - Major
to Minor Sort order.
Note that FoxPro compound indexes (.CDX), do not consider
CAPITALIZATION. The AA's and BB's will be together in one group
and the aa's and bb's will be in a separate group. Whenever you
add - <INS>ert more sort definitions, the fields are
automatically surrounded by UPPER(<fieldname>). UPPER simply
converts values to uppercase, so that all A's are together and
all B's together regardless of capitalization. You can also
<E>dit your sort definition any way you want.
WHICH RECORDS ?? FLEXI-SELECT
===============================
The "SELECT ALL RECORDS" is always the #1 selection. You can add
<INS>, delete, <DEL>, or <E>dit your selections. Flexi-Select
allows you to see specific records in your Browse Screens, or
Reports, or Labels.
When adding a Flexi-Select option you will be asked to select a
FIELD (If you just want to see certain last names, you'd select
LASTNAME). After you've selected the field, you'll select an
OPERATOR. An example of an operator is: 'equal to' or 'greater
than'. Next, you will be asked to enter a value to be tested
for (eg. Last Name='SMITH').
Finally, you will select QUIT, or select a CONNECTOR to link
additional selections, like below:
Examples: Last Name='SMITH'
Last Name='SMITH' .OR. Last Name='JONE'
Last Name='SMITH' .AND. Zip<>'666', etc.
Note that B&B will automatically insert the word "UPPER()" around
your sort definitions. This allows you to see all records
whether they are entered into your data file as SMITH or Smith.
B&B DOALL User's Guide 11
You can eliminate UPPER() if you need to by using the <E> to
edit.
The <E>dit feature in Flexi-Select allows you to be more precise
in the selection of your records. The reason for this is that
the use of parentheses allows better Boolean logic. B&B will not
automatically insert these parentheses because it really can't
determine the placement of parentheses in a multitude of .AND. or
.OR. statements. For example, the following two expressions will
select different records simply because of careful placement of
parentheses. This is BOOLEAN logic and it basically goes like
this: Line #1 (below) will select all records having a Last name
equaling 'SMITH' and not having a zip code starting with '666'.
After that test has BEEN MET, other records whose Last name may
NOT be 'SMITH' will be selected as long as the zip is not equal
to '555'. Line #2 will select just the records having a Last
name equaling 'SMITH', and once that test has BEEN MET, THAT
record cannot have a zip code of '555' or '666'.
Last Name='SMITH' .AND. Zip<>'666' .OR. Zip<>'555'
Last Name='SMITH' .AND. (Zip<>'666' .OR. Zip<>'555')
If you are familiar with FoxPro commands, you can also use the
edit function to customize your own selections such as DELETED()
which selects only records that are marked for deletion.
SPEED TIP: Instead of using Flexi-Select to look at the records
with a lastname of "Smith", use Flexi-Sort and pick the lastname
sort. Then, when in the browse screen, use the Find Record top
menu option to find "Smith". This is faster.
Once in the Browse screen, you will see options at the top of the
screen. One of them is "Browse". Highlighting and <Entering> on
this option will give you an ability to add, and mark records for
deletion.
FIND RECORDS
------------
Other options are "Find Records" which will allow you to search
for a record based on a value in any field. In addition to
searching for values in any field, you can look for addresses
that BEGIN with "123" OR have "123" ANYWHERE in the address
field.
SEARCH/REPLACE
--------------
Another option, "Search and Replace", is very powerful. It
should only be used after making sure you have a backup file, and
you have used Flexi-Select to pick the appropriate records first.
After selecting this option, you can say, replace all Last Names
with 1)BLANKS by entering 1's in the replace value, with
2)"SMITH" by entering "SMITH" in the replace value, or 3)Proper
capitalization by entering the word "PROPER" in the replace
value, or a 4)VALUE FROM ANOTHER FIELD by selecting the other
field for the replace value.
B&B DOALL User's Guide 12
In regards to #4 above, you can replace one type of field
(Character) with the value in another type of field (Numeric),
but be cautious. Make a backup copy first. Not all values are
replaced accurately, especially if some character fields contain
both numeric and non-numeric characters.
TIP: Remember that prior to entering the Browse screen you will
select a SORT. If you are "replacing" values in THE SAME FIELD
AS THE SORT FIELD, you will get unpredictable results. Use a
different sort if this is the case. For example if you wanted to
replace all of the EMPTY Company names with ACME, the first empty
record will become ACME, and it will suddenly be at the bottom of
the file (and finished with replacing) because it is sorted by
Company name.
HELP FILE
=========
The Help menu option will access the helpfile.dbf and is
modifiable by the user for customization.
If you are in your file and would like to be able to access a
"popup" or "lookup" file of say Zip Codes when you are in the ZIP
field, OR valid codes when you are in your field called CODE,
just press <F2>. If a file called ZIP.DBF or CODE.DBF exists, it
will "popup" for you to access.
NOTE: if you don't have any popup data files, you can create your
own by entering DOALL ZIP, or DOALL CODE. You will then have the
option of creating these files.
LOOKUP FILES - BROWSE SCREENS
=============================
A Browse Screen looks like a spreadsheet with rows and columns.
Records are displayed horizontally in rows and each field is
listed vertically in columns. Occasionally, only one record will
appear to be displayed on a page, this is the "CHANGE" mode. If
you use your <ALT> key to highlight the BROWSE option at the top,
you'll see that you can toggle between the BROWSE/Grid mode and
the CHANGE/individual record display. When in the Browse mode,
entering <F2> will access other data bases for additional
information. When your cursor is on a field, you can press <F2>
to access a lookup .dbf file. The lookup file name must have the
same first 8 characters as the field name. For example, if the
data file you are currently maintaining has a ZIP CODE field,
pressing <F2> while your cursor is on the zip field will attempt
to locate and display a file called zip.dbf. If the lookup file
does not exist, a message will tell you. You can create new .dbf
files to support lookup tables on each and every field.
HOW ARE LOOKUP FILES USED?
Lookups are used for a variety of reasons, 1. <F2> in a zip field
will assist in reducing data entry, because you can enter the zip
10001, then <F2> to display all zips from zip.dbf, and then
B&B DOALL User's Guide 13
<Enter> to "FILL-IN" the zip, city, state, etc. from the zip
file. Whenever your main data file and lookup files have the
SAME field names, <Enter> copies information from all of the
fields in the "Lookup" file to the main data file - a quick way
to fill in STATE, CITY and ZIP by entering just the zip code.
2., you can also use the lookup files for reference purposes.
Let's say you have a file called vehicle, with a field called
serv_code containing codes for the types of services performed.
If you don't remember what the serv_code ALIGN means, you can
press <F2> on the serv_code field to access a serv_cod.dbf file.
You can then peruse the serv_cod.dbf file to see that ALIGN =
ALIGNMENT, BRAKE2 = 2 WHEEL BRAKE JOB, BRAKE4= 4 WHEEL BRAKE JOB
etc. You can make your own .dbf files for lookup purposes on
ANY field. Hint: give your .dbf file the same name as the first
8 characters of the field name.
KEEP SAME FIELD NAMES IN LOOKUP ?
---------------------------------
If creating a Lookup file, remember to create the new file using
the same field names (and lengths) as your master file. If your
master file has ZIP 10 long, STATE 2 long (or 10 for
international purposes) and CITY 20 long, then create the same
fields in your lookup file. The reason for doing this is when
accessing your lookup file and finding the appropriate record,
when hitting <Enter>, values in the lookup file ZIP field will be
copied to the ZIP field in the master file, and CITY, and STATE,
etc. Conversely, if you have a field in both files you don't
want changed, say "description", when you press <Enter> the data
in the description field from the lookup file will overwrite the
description data in the main file.
LOOKUP FILE OPTIONS
-------------------
When the lookup file is displayed, you will see that some
additional options are available. To maintain data integrity you
will see that the DEFAULT mode does not allow editing of the
lookup values, but you can switch to edit mode. You can also
search for values, in either the first field, or second field (if
available). You can also perform import/export functions (for
example, to add another state's zip codes file to the existing
zip lookup file. You can also Pack (remove records marked as
deleted, or list all of the records to your printer.
Function keys allow searches on the first or second fields. If
you want to find the zip code 54333, enter "5" and you will see
the first record with a "5". Enter a "4" and you will see the
first "54" record. This process can continue until a NO FIND
occurs, in which case, the process starts over again. Note: with
the Zip file, if you enter a #, the file will be displayed in
numerical order. If you enter an alpha character (A-Z) to find
the city, the file will be displayed in CITY order.
If there are more fields in that file than will fit in the width
B&B DOALL User's Guide 14
of the screen, you can use the arrows or tab key to see more
fields.
You can also import/export data directly into, or from, your
lookup file.
TIP:B&B Systems makes available the latest Zip Code data for the
USA, or in separate zip files for each state. If you have a
modem, you can download these files free from B&B System's
bulletin board, P.C. Manager. To import these files into the
Zip.dbf file. Simply select Import when in the lookup process
<F2> on the zip field. Select the file type (our zip files are
provided in Dbase/FoxPro format) and enter the name of the file
to be imported, such as ZIPIL.DBF. Note: for zip files, they
commonly contain 10 characters for the ZIP code, 2 characters for
the STATE code, 20 characters for the CITY, and 25 characters for
the COUNTY. If your master file has fields with these same
names, and if you used the lookup <F2> function in the zip field,
while in the add mode, your B&B system will "fill-in" the zip,
city and state names after you <Enter>. Some companies use a 10
character state field to accommodate international names (ie.
CANADA).
ADDING RECORDS
==============
DUPLICATE CHECK - Prior to ADDING RECORDS _________________________________________
After selecting the ADD option from the menu, you will be asked
to enter a value for one of the fields for the record you are
adding. The default is the first field, but you can change it by
selecting "Setup" from the menu (<ESC> when asked to select a
field in setup will cancel any duplicate checking). This is a
way of checking for duplicates prior to adding records. If
similar records are found, they will be displayed in a browse box
at the bottom of the screen. You can edit the duplicate records,
or <ESC> to continue adding.
CUSTOM ADD SCREEN
=================
NOTE: A .PRG file is made for you the first time you add a
record. The .PRG file name defaults to <dbf filename>.PRG. You
can modify this file, or make your own. Then compile it (Using
FoxPro which creates an .FXP file). You can incorporate the
lookup functions, like FILELOOK() - see below - into your custom
screens or you can change the order of data fields. If you don't
compile it, a simple add screen, without special functions will
be used.
Edit this .PRG file (Use a word processor that treats the file as
a DOS TEXT or ASCII file, or you can use the Edit file/Setup menu
option). When you see the .PRG file, you'll see that information
is displayed in the ADD screen by using the commands "@ <row>,
<column> SAY <text>". Data Entry boxes are displayed with the
"@ <row>, <column> GET <m.fieldname>" command. That's it. Those
two commands are all you need. NOTE: if you are working on a
B&B DOALL User's Guide 15
normal monitor with 25 lines of text (vs. enhanced mode with up
to 43 or 50 lines per screen - See Setup), don't modify your
<data file name>.PRG to display something on row, say 60.
But, there is an important extra feature that you can use if you
would like to control data entry. After any GET command, you can
use a special command called "VALID <command>" to check the data
being entered. You can use simple validation checks such as:
VALID(m.ZIP>'55555'.AND.m.ZIP<'66666'). OR, the control can
access another data file for "lookup checks". For example, the
following two lines:
@ 1,1 SAY 'Enter ZIP:'
@ 1,12 GET m.ZIP VALID filelook(VARREAD(),.t.,.f.)
does several things. It would display the words: Enter ZIP: at
row #1 and column #1. It would also display a data entry box for
the ZIP field at row #1 and column #12. Note: the preface, m. is
required in <dbf filename>.PRG files used when adding records, it
is not used in <dbf filename>.FMT files used when using F10 in
the browse screen to edit records. There are three values within
the parentheses after the VALID filelook command. They do the
following: VARREAD() says if you have a data base file with the
same name as the variable being read, in this case ZIP.DBF, open
the file. The first .t. (a true value) and determines whether to
"SHOWLIST THE POPUP IF EXACT MATCH FOUND". If this is true, and
data has been entered that exactly matches one of the values in
the zip.dbf data file, then the file will "popup" anyway. If the
"SHOWLIST IF EXACT MATCH FOUND" value is .f. (false), then if you
say, enter a valid zip code, then the file will not pop-up.
The second .f. is a SEARCH IF EMPTY indicator. If nothing -
blank is entered into a field, it will not check for a valid
value. If you want the pop-up to appear, forcing a selection
from the pop-up file, use .t. (true).
Repeating Data ______________
When adding records, you can have specific data repeatedly "fill-
in" data into your file. How? Create a <dbffilename>.REP file
(see Setup Menu) which is a one record file with the same
structure as your regular file, and you will be asked to fill in
the data you desire to have automatically "filled-in" every time
you add a record. The system will search for this file, if
available, any values in the .REP file will be moved to the add
screen. (Handy for repetitive STATE, AREA CODE, CITY, etc.
ADD Dates _________
In some applications, it is handy to have the "date a record was
added", for example, I now want to print labels for records I
entered in DECEMBER, 1992. B&B DOALL will automatically enter an
"Add Date" in your newly added record if you have an "ADDDATE"
DATE field. If you would like to add an ADDDATE field, select
MODIFY STRUCTURE from file maintenance, and go to the bottom of
the field list. Add "ADDDATE", Type=DATE.
B&B DOALL User's Guide 16
Anytime you add records, the current date will be entered. When
you want to print labels, or a report containing just records
added in DECEMBER, 1992, Use FLEXI-SELECT to add a selection
"ADDDATE=' / / '". Don't worry about adding a date yet
because you will need to <E>dit this selection. <E> to edit, and
put "MONTH(" in front of ADDDATE, and ")=12" after it. If you
also want just 1992 records, edit this line to look like:
"MONTH(ADDDATE)=12 .AND. YEAR(ADDDATE)=1992"
HOW DO I USE THIS <filename>.PRG FILE??? ________________________________________
BUT, before your system can use this format file, it needs to be
compiled (changed to a .FXP file). If you have FoxPro you can do
it yourself by starting FoxPro and selecting the COMPILE option
under PROGRAM in the top menu. Or, you can have B&B Systems
compile it for you. Send it to us on our BBS. There is a small
fee, and you can download it within 48 hours.
CUSTOM EDIT SCREEN
==================
Normally, when you edit a record, the browse screen is displayed.
You can also have a custom edit screen. The file required is a
.FMT or Format file, similar to the .PRG type file discussed
above for custom add screens. Both type of files have @ 1,1 SAY
'ZIP:' and @ 1,20 GET m.zip type commands. The MAIN difference
is that the add screen (.PRG) accesses memory variables, so the
field zip is prefaced with an "m.", as in m.zip. The edit (.FMT)
screen edits the .dbf data directly, so use just @ 1,20 GET zip.
You can even create this file by copying your <dbf filename>.PRG
to <dbf filename>.FMT. Get rid of any "m." notations and compile
this file (or have B&B Systems do it for you to create a .PRX
file). Then, when in the browse screen, use F10 and your records
will be displayed in full screen format, using your .FMT/.PRX
file.
CUSTOMIZATION
=============
B&B Systems are specialists in data base systems. We offer
customization services.
You can add some customization yourself. If there is a special
option that you would like to add, B&B DOALL automatically
searches for any file called CUSTOM.FXP every time DOALL is run.
(an .FXP file is simply a .PRG program file that is compiled with
FoxPro by running FOXPROL and selecting "Program", "Compile"). A
sample custom.prg and custom.fxp file is supplied. Look at the
custom.prg file and you'll see that it shows how you can sense
when a specific key is pressed and call another program. The
sample custom.prg file includes the sample ON KEY LABEL CTRL+F2.
As long as the file custom.fxp is on the DOALL directory, you'll
notice that after you start DOALL and hit <Ctrl><F2>, the product
file will appear for your reference.
B&B DOALL User's Guide 17
You can accomplish your own customization with the line:ON KEY
LABEL CTRL+Z DO MYJOB. Then, make an ASCII type file called
MYJOB.PRG with your word processor containing the appropriate
FoxPro commands to accomplish the task you desire. Then make a
compiled file with FoxPro called MYJOB.FXP. Anytime you press
the <Ctrl-Z> keys, whatever commands you put in MYJOB will be
executed. Careful: avoid assigning custom jobs to key
assignments that are used for some other purpose in DOALL.
UPDATES
=======
When updates become available, registered owners are eligible for
upgrades at one half the original cost. And, because DOALL is
based on FoxPro, When FoxPro versions for WINDOWS and UNIX
appear, DOALL will also support these operating environments.
CALLBACK FIELD
==============
You may want to be automatically notified when customers require
your attention on a future date. If you have a "DATE" type field
in your file called CALLBACK, every time you startup DOALL, this
field will be checked. If you have any records in your file with
a CALLBACK date greater than the current date, a browse screen
will be shown on the screen (in descending callback date
sequence). You can then act on these customer records.
If you don't want to see ALL callbacks in the future, but only
those in the next two weeks, you can define the span of days you
want to see in the setup menu.
LABELS & REPORTS - ALSO see SQL
===============================
Some Sample Label & Report files are provided with DOALL. You
will NOT be able to use them AS-IS, unless the fields in your
data base HAPPEN to be the same as those defined in the label,
such as LastName, or Address.
You make your own new labels or reports by selecting ADD report
or label from their respective menus. You can edit existing .LBX
label and .FRX report format files from the Edit option in the
Report/Label menus (.LBX and .FRX files are modifiable FoxPro
Label and Report files). Enter or Change the names of the fields
to match your data base. If you don't know the names of the
fields in your data base, highlight the LABEL or REPORT menu
option at the top of the screen, and select FIELDS. A window
will be provided to enter the field name into a value called expr
(expression). If you click your mouse on "expr", another window
will display the field names.
When adding new reports, you can get a quick start by clicking on
REPORT at the top menu, then select Quick Report/Label to have
all of the fields inserted into an empty file.
B&B DOALL User's Guide 18
IMPORTANT: when adding fields in labels, or in the Quick Report
option in reports you will see an option to "ADD ALIAS" to the
field name. Click on this option to turn it off. Do not use
this option. The Alias is the file name prior to the field name,
separated by a period (.), such as myfile.lastname. Just use
lastname. The reason for this is with the new, faster SQL method
of accessing data, a duplicate of your main file is made and this
temporary file name will not match your main file name.
The only exceptions to using alias's are the special Rep and
Distribu.frx reports supplied with this system.
WHAT IF I HAVE FOXPRO?
======================
REPORTS
If you have FoxPro, and if you have the PATH COMMAND setup to
allow access from any directory, you have more features available
to you. For example, if you have FoxPro and a B&B system, enter
FOXPRO (or FOXPROL for a LAN) <B&B system name>. You will then
have the capability of using the SQL Reporting feature. You can
run predefined FoxPro LABELS/REPORTS files, or define your own
field selections within SQL.
To get started with SQL, try the following: Select SQL from the
report menu, and when prompted for the name of the existing Query
file, <Tab> to NEW. You can add to the selected data files in
the top left box. To send a simple report to a file for
LASTNAMES equalling SMITH, Double Mouse click, or <Tab> to and
<Enter> on the "Field Name" box in the lower section. Select
LASTNAME from the list of fields, and enter SMITH in the
"Example" box.
Next, <Tab> to Output box and <Enter>. Select "screen display"
and "output to file". Enter TEMP for a file name and <Tab> to
<OK>. Then select <<DO QUERY>> to produce your report.
There are so many other options and features in SQL that we can't
address them all here (See FoxPro Interface Guide), but you can
do just about any data reporting in SQL and quickly.
SQL QUERIES are save in .QPR files.
Hint: When creating or editing these SQL reports, as well as the
standard .FRX type reports, you will find the task MUCH easier if
you have a mouse. Most of the time you can get to all of the
screen options with <TAB>. If you are moving a field in an .FRX
report, you can just hold the left button down and move things
around. Without a mouse, you probably will need a FoxPro manual
to figure out all of the keystrokes required to move a field
around.
LETTERS
-------
You can select Letters from the browse mode, or the main menu
B&B DOALL User's Guide 19
where you will be prompted for your desired SORT and which
records to SELECT. Then you will see the "letters box" you can
use your <TAB> and <Up/Down> arrows to select a letter. When you
<TAB> to the other options, like print, you'll notice that the
last letter you selected is marked. That is the letter that will
be printed.
To Edit a letter, <Enter> on a highlighted letter, or <TAB> to
select the <Edit Letter> option. You will be in the built-in
editor to make changes to your letter.
To Print a letter, <TAB> to print.
Options will give you the opportunity to enter printer commands
(for two tray printers) that will force tray one when printing
page 1, and tray two for the remainder of the pages (Page 1 =
Letterhead, Remaining Pages = Bond).
Options will also allow you to turn the BELLRINGER option on. If
this option is turned on, AND if you have a character type field
called bellringer in your data file, AND if there is data in it,
your printer will PAUSE after printing the letter and the bell
will ring. This is for giving special handling to letters, such
as entering "ADD CATALOG", or "HOLD" in bellringer to give you an
opportunity to do something special with the letter.
Letters - Adding Variables with brackets - use <<field name>>
-------------------------------------------------------------
To insert variable information into your letters, surround the
variable name (such as Firstname) in double brackets -
<<Firstname>>. If you also want to print the Lastname, and if
the Firstname field is 20 characters long, then you'll want to
avoid any trailing spaces when the actual name is BOB. To avoid
the 17 spaces following "BOB", use the TRIM command and enter
<<TRIM(Firstname)>> <<Lastname>> into your letter. Note: you can
preface the field name, firstname, with the file name as in:
sample.firstname. This tells B&B DOALL which file the data is
located. If you access many files and want to use the same
letters for all of them, just use <<Firstname>> in your letter,
but make sure that there is a Firstname field in each of your
data files.
Letters - Merge Other letters/text into main letter with ADDLTR()
-----------------------------------------------------------------
Besides inserting field/variable data using the << >> brackets,
you can "insert" or merge letters into your main letter using the
addltr() function.
You accomplish this by using a function called
<<addltr('ltrname')>>. As an example, if you always want your
letters to end a certain way, make either a DOS file called
END.LTR, OR just add a letter to your letter file and give it a
name of END.LTR. Once you have made this letter, insert
B&B DOALL User's Guide 20
<<addltr('END.LTR')>> at the end of your main letter. Then, when
printing your main letter, and <<addltr('END.LTR')>> is
encountered, the text from END.LTR will be inserted into your
main.ltr.
1. In example #1, you can automatically insert an existing DOS
file by explicitly entering the DOS file name in your letter,
like:
<<addltr('c:\filename')>>
2. In example #2, you can automatically insert the wording from
one of your other letter files. Letters are stored in the
ltrs.dbf file, and you can store all of your letters in this
file. Use the same syntax as in example #1, but insert the name
you assigned to the letter in quotes, like:
<<addltr('form.ltr')>>
3. In example #3, you can PERSONALIZE you letters to match the
data in your file. If your data file has any fields like
AINTEREST, BINTEREST, CINTEREST, etc., and if you entered data
into those fields that identified the person's interest, you can
use ALLCODES instead of the actual letter name, like:
<<addltr('ALLCODES')>>.
For example, let's say you want to print letters to prospective
customers, but these letters should only pertain to specific
needs or interests of these customers (or prospective customers).
You need two things to produce these letters. Number one, you
need to have fields in your data file called AINTEREST, BINTEREST
... ZINTEREST. Number two, insert <<addltr('ALLCODES')>> into
your letter. This is what will happen DOALL encounters
<addltr('ALLCODES')>>: If the record has "PENCILS" in the
AINTEREST field, and "ERASERS" in the BINTEREST field, the
LTRS.DBF file will be searched for a record with "PENCILS" in the
name. If not found, the current Operating System directory will
be searched for a file called "PENCILS". Any text from
"PENCILS" (then "ERASERS") will be inserted into your letters.
These letters can be product explanations, price lists, etc.
Thus, your letters will contain text addressing specific customer
interests.
Letters - add SALES REPS/LOCAL OFFICES info.
--------------------------------------------
A sample REP.DBF file is provided with your system. This file is
intended to contain information on all of your sales personnel:
Codes (usually initials), names, phone numbers, etc. It can be
used as an <F2> Lookup file if you have a field called REP in
your main data file.
But it can also be accessed to insert personalized endings into
your letters. When you print letters this REP file must be
"open" and "related" to your main data file. This is
B&B DOALL User's Guide 21
accomplished in the custom.prg file. Refer to the section in
custom.prg where the REP file is opened and the "SET RELATION"
command is issued.
NOTE: asterisks at the beginning of command lines in custom.prg
should be removed. Then you will need to compile custom.prg to
make a new custom.fxp FoxPro file. You need FoxPro and issue
the "compile custom.prg" command.
Here's how it works: If you have a value of "BBB" in the rep
field of your main data file, when you put <<REP.rphone>> into
your letter, the REP file will be searched for "BBB", and
whatever value is in REP.rphone will be inserted into your
letter. The same holds true for <<REP.name>>, <<REP.address>>.
You need 1) to have a character field called REP in the data file
you are using, and 2) you need to have added the records for all
of your sales reps or local offices in your file called: REP.DBF.
Letters - add DISTRIBUTOR info.
-------------------------------
If you send letters to sales leads, you can automatically add a
qualified distributor (or list of distributors) to your letter.
Insert this in your letter: <<addltr('DISTRIBUTORS')>>.
See how this coding appears in the sample DISTRIBUTOR letter.
When this addltr code is encountered, the system then looks for a
file called DISTRIBU.LTR, also provided in your sample letters to
determine which <<variables>> to print.
You need 1) to have a character field called DISTRIBU in the data
file you are using, and 2) you need to have added the records for
all of your distributors in your file called: DISTRIBU.DBF.
B&B DOALL User's Guide 22
SAMPLE LETTER (DISTRIBUTOR in LTRS.DBF) SHOWING HOW TO
INCLUDE DISTRIBUTOR DATA IN YOUR LETTERS:
+---------------------------------------------------------------+
| ==================== |
| YOUR LETTERHEAD |
| ==================== |
| |
| |
| DATE |
| |
| NAME |
| ADDRESS |
| CITY STATE ZIP |
| |
| |
| DEAR : |
| |
| |
| |
| Hello, this is our ... |
| |
| |
| |
| |
| |
| Contact a Local Distributor: |
| ---------------------------- |
| <<addltr('DISTRIBUTORS')>> looks for distribu.ltr for |
| the <<field definitions>> |
| |
| Company: ABC Distrib. Contact: Jim Jones |
| Address: 123 Main St. Chicago, IL 60001 |
| etc. |
| etc. |
| |
| |
| Thank you for your interest ... |
| |
| I.M. Manager |
| |
| |
| |
+---------------------------------------------------------------+
FOLLOW-UP REPORTS for SALES REP/LOCAL OFFICES
FOLLOW-UP REPORTS for DISTRIBUTORS
---------------------------------------------
If you send letters to sales leads, and reference Sales
Reps/Local Offices in your letters, you can produce reports to
your Sales Reps or Distributors that they can use to follow-up on
your initial letter.
B&B DOALL User's Guide 23
Here's what you need to produce these reports: 1. You need a
"REP" and/or "DISTRIBU" field in your main file (supplied in
sample.dbf file). 2. You need a Rep.dbf and/or Distribu.dbf
(these sample data base files are supplied with the demo). 3.
And lastly, you need to enter your codes. When you put a sales
rep/local office code of JJ (Jim Jones) or CHICAGO in your main
file, you also need to add a record for JJ or CHICAGO in your
Rep.dbf. How do you add a record to the Rep.dbf file? - Just use
the Setup menu option to Select A New Data File and pick Rep.dbf.
Add new records just like you would in your main file.
Then, if you decide to print a report after printing letters,
here is what happens: If a letter had a REP code of JJ (Jim
Jones), the Rep.dbf will be scanned for the JJ code. If the JJ
value is found in the rep.dbf file, a report will be produced
that you can send to Jim Jones CONTAINING A LISTING OF ALL
LETTERS THAT YOU JUST PRINTED WITH JJ in the rep field. If JJ is
not found in the rep file, a report will be produced with a blank
for the rep value. The same process applies to the Distributor
reports.
If the REP field in the main file is 6 characters long, and you
wish to make it 10 characters long, just use the File Maintenance
menu option to Edit the fields. Remember that you should also
change the REP field in the Rep.dbf file the same way.
NOTE: The layout of these reports are controlled by the FoxPro
report format files DISTRIBU.FRX and REP.FRX, and can be modified
by you. Use the Edit Reports option and you can move data
around, or add more Sales Lead information (like the specific
interest the lead has), or move the distributor/sales rep
name/address so that it appears in your window envelope.
B&B DOALL User's Guide 24
In the example below, three Letters are produced. Each Sales Lead
has the DISTRIBUTOR and SALES REP/TERRITORY code shown under each
letter.
+-----------+ +-----------+ +-----------+
| | | | | |
|to:A.Smith | |to:B.Jones | |to:C.Kline |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
+-----------+ +-----------+ +-----------+
Distrib=Acme Co. Distrib=Carter Co. Distrib=Carter Co.
Rep/Terr=BB Rep/Terr=Main Rep/Terr=BB
After printing letters, you can print these reports of Sales
Leads for your:
DISTRIBUTORS and/or SALES REP/OFFICES
+- ACME Co.--+ +--MAIN OFFICE-+
| A.Smith ..| | B.Jones ... |
| | | |
| +- CARTER Co.-+ | +--- BB REP ----+
| | B.Jones ... | | | A.Smith ... |
| | C.Kline ... | | | C.Kline ... |
| | | | | |
+-----| | +-----| |
| | | |
| | | |
+-------------+ +---------------+
Distributor Follow-up reports - coding issues
Distributors - Restricted territories
-------------------------------------
If your distributors have restricted or protected territories,
you would literally insert the appropriate distributor code for
each record in your data file, like using "ACME" and "SMIT" to
identify Acme and Smith Distributors. In the DISTRIBU.DBF file
add records for two distributors, "ACME" and "SMIT".
Distributors - Overlapping territories
--------------------------------------
If a Sales Lead could have multiple distributors, you need to
establish codes differently. You can't identify multiple
distributors in one field called DISTRIBU. Or can you? It is
recommended that you set up your distributor code with a "left to
right" order of preference. For example, if your market is the
United States, the largest, most universal reach for any of your
distributors would be the United States. This is how the codes
would be set up in the DISTRIBU.DBF: distributors that cover your
entire market, code them with a "U". For distributors that cover
B&B DOALL User's Guide 25
just the Midwest, use a code like "UM". For distributors that
cover just Illinois, code them "UMIL".
If you want your sales lead to know about all of the midwest
distributors, put "UM" in the record. Then all distributors with
a "UM" will be printed in your letter (including those Illinois
distributor records with UMIL). If your sales lead record has a
"UMIL" in it, then all distributors with just a "UMIL" will be
printed. Be careful, if you have a sales lead record with just
a "U", all of your distributors starting with a "U" will be
listed in your sales letter.
This same technique can be used with zip codes. Several
distributors may service the 601xx zip code area, and have a
"601" code. The Sales Lead, in the 60101 zip code, could have a
distributor code of "601" to reference all the "601"
distributors.
When you print your follow-up reports for sales reps/local
offices, you get one page per rep, with the individuals listed
below. When you print follow-up reports for distributors, you
may have more than one distributor with the code "UM". The
result will be a report for "UM" distributor "Midwest Incorp."
and another for "UM" distributor "Allstate Midwest". The same
individuals (coded "UM" in the distribu field) will be listed in
each report.
TICKLER LETTERS
Tickler letters can be handled many different ways. Since you
can have any fields called ACTDATE1 and ACTION1 automatically
filled-in with the letter date and (.LTR) file name (when a
letter is produced), you can elect to send tickler letters (use
Record Selection) to any record having a BLANK ACTION1 field. Or
you can use any Selection like: blank ADDDATE, or records with
any value in any field.
If you started printing letters, but only finish half, you could
add a Flexi-select excluding those already receiving a letter
such as: ACTDATE1 - not equal - DATE of FIRST LETTER RUN.
If you want to manually control the production of a tickler
letter, you could edit records to change the ACTDATE1 to a
desired future date, and enter "TICKLER" in the ACTION1 field.
Use your record selection to print letters for records with
ACTION1='Tickler' and ACTDATE1="today's date", or greater than
today's date, etc.
PROMOTION LETTERS
We strongly urge the use of an interest code (or multiple
interest1 and interest2 fields, etc.) in your data file. When
you communicate with this Sales Lead (or get a postcard back),
enter PLANE390 if he's interested in that model of plane.
B&B DOALL User's Guide 26
If you have a promotion or a special sale price planned for MODEL
#390 airplanes, you could develop a promotion letter called
390PROMO, then print letters for Sales Leads having an interest
code of PLANE390.
QUOTE LETTERS
If you put quote dollars (and maybe the quantity for the quote)
in your data file, you can reference this amount in a special
quote letter you can develop (see <<variables>>)
What letter was sent when??? - ACTION FIELDS
--------------------------------------------
When producing letters, you may want to keep track of the last
letter sent and the date sent. The system will sense if you have
a character type field in your data file called ACTION1, and a
date type field called ACTDATE1, after your letter is printed you
will be prompted if you want to put the letter "name" and the
current date into these two fields automatically. If multiple
letters are produced at one time, and you respond yes the first
time, these two fields will be updated automatically for the rest
of the letters.
If you want to keep track of the last four letters, put the
following fields in your data file: ACTION2, ACTION3, ACTION4,
ACTDATE2, ACTDATE3 and ACTDATE4. If these fields exist, your B&B
system will automatically move the data that was in ACTION1, and
move it to ACTION2, ACTION2 data will be moved to ACTION3, and so
on. The same is also true for the date type fields.
MULTIPLE LABELS - for ONE RECORD
--------------------------------
If you select "Labels" from the menu, you can print multiple
labels for one record. For example, if your data file contained
records of garments (price, style, size), and you wanted to print
200 price tags for record # 10 (Button Down Shirt), Use FLEXI-
SELECT to select STYLE='Button Down', and then produce labels.
You can create any type of label format, in any number across to
make multi-part price tags, company labels, whatever.
PRINTING TIPS
=============
CONTROLLING PRINTER -
LABELS FROM DISK FILE
---------------------
When you have selected to send labels or a report to a disk file,
you can control how the data appears by controlling the printer.
For example, with H/P laser printers, you can manipulate the
printer to control labels output:
1. Press the ON-LINE button to take Laser Printer OFF-LINE
B&B DOALL User's Guide 27
2. If you want to print 12 characters per inch instead of 10
(commonly needed when trying to printing and fit 3-across labels
on 8-1/2" x 11" stock). Press menu button to get to font #, use
the +/- buttons to change font # to 2. Press Reset button to
make the asterisk appear on right (default).
3. Press menu button again, until you get to Lines Per Page,
press "+" button to increase to 63 lines per pages, and press
reset button again. Keep pressing menu button, Until READY
appears. Put back ON-LINE.
To change back to original status, do above using "+", "-" keys
to bring font to "0" and lines per page to "60".
EXTRA SHEETS EJECT
------------------
On some printers, when printing reports, labels, or letters and
also define a top margin greater than 0, blank lines may be fed
to your printer for the next sheet. You can avoid this by
inserting extra lines at the top when initially defining your
letters or labels.
PRINTING BARCODES ON LABELS
===========================
1) For Laser Printers, make sure you selected Laser during
installation. B&B DOALL's Bar Codes have been U.S.Postal Service
certified when using a Hewlett-Packard compatible Laser Jet.
The barcodes require that your printer utilize the PCL Language
and associated ESCAPE code sequences.
BUT, since printer models are constantly changing (even Hewlett
Packard), you should print a sample of the barcode with your
printer and submit the sample to a major Post Office in your
area. They can confirm that the bar code is acceptable. DO THIS
PRIOR TO PRINTING HUNDREDS OF BARCODES THAT MAY NOT BE
ACCEPTABLE. B&B SYSTEMS ARE NOT RESPONSIBLE FOR ANY EXPENSES
INCURRED IF YOU DECIDE TO RISK NOT HAVING YOUR BARCODES VERIFIED.
Also, barcode location on mailing pieces are critical, please see
the U.S. Postal Service for information on placement.
TO PRINT BARCODES:
2) Edit a Label Form and enter: BARCODE(#) on one of the lines
desired. The line where BARCODE(#) is entered determines
vertical placement. Horizontal placement is determined by the #
within parentheses. # is the number of inches (in tenths) to
indent from the left. For Example: barcode(30) on the fifth
line will print 5 lines down, and will print the barcode 3 inches
from the left (30/10).
3) Zip Codes NEED TO BE 9 DIGIT ZIP CODES. That is what is the
barcode is, graphic representation of the 9 digits.
PHONE DIALING W/MODEM
B&B DOALL User's Guide 28
---------------------
If you have a modem, and would like to have your B&B system dial
phone numbers for you, here is how you set it up: Connect a
modem to the phone line you will be using. Have a telephone
available on that same line (You can connect a phone to the
"PHONE" jack on the back of most modems).
When you are in the Browse screen, use <ALT>-D or your mouse to
highlight the DIAL PHONE option. Your file will be searched for
any fields that have the word "PHONE" in them. If only one field
is found, and a phone number exists, dialing will start. If
multiple fields like HOMEPHONE and BUSPHONE are found with phone
numbers, they will be displayed for you to select the one to
dial.
Select one of the numbers to start dialing, and you'll hear the
modem dial. If you have a "MEMO" type field in your data base,
you will also be prompted for a TOPIC of the call. You can enter
"Left Message" and this will be inserted into the memo notes. If
you enter ? it won't be found in the topic.dbf data file and you
will be presented with a list of topics and you can just select
and <Enter>. You will also be asked if you want the date and
time inserted for you. You will then be presented with the memo
editor screen, and you can expand on your notes while talking.
You can hang up the phone at any time, and then save your notes.
NOTE: If you want to dial multiple numbers at one time, see the
file custom.prg. In it, move asterisks to change the command ON
KEY LABEL F4 DO PHONE WITH 'ONE', to WITH 'ALL'. Then compile
this file to make a new .FXP file. This will allow you to skip
through all of the records, or those you've selected in Flexi-
SELECT, and display the phone numbers one by one.
If your file has a date type field called CALLBACK, you will have
the option of updating the callback date. After your phone call,
you will be shown a list of "future time values", such as one-
week, one month, or two months to have entered into the callback
date. If the current date is January 1 and you wish to be
reminded to callback in one month, select one month from the
callback.dbf list and February 1 will be entered into the
callback field of your file. (See section regarding callback
reminders during startup).
Note that in the list of "future time values", the current
callback value is at the bottom of the window. If you don't want
to change the current value, use <ESC>ape. The list of future
time values are stored in a data file called callback.dbf. If
you are not satisfied with selecting between a callback period of
one week or two weeks, and you want to add a future callback of
10 days, add a record to this callback.dbf file by Selecting a
New Data File from the setup menu.
B&B DOALL User's Guide 29
DUPLICATE CHECKING
------------------
B&B Systems offers both SOUNDEX (sound-a-like) and EXACT testing
of records in your file. Exact matching will NOT uncover
differences in spelling. If you have two records, one with a
last name of SCHULTZ, and one with SHULTS (with matching first
names and city names) exact matching will not identify them as
duplicates, but Sound-alike may. NOTE: The Soundex process
generally ignores vowels.
Once you've selected the type of matching you prefer, the next
step is to select WHICH RECORDS and WHICH FIELDS of data are
compared. If you are going to compare phone numbers, and have
many records with no phone numbers, you may want to add a Flexi-
Select to pick phone numbers that ARE NOT BLANK
(ie. PHONE<>' '). This way you won't see a large number
of duplicate records that have empty phone numbers.
The system will provide a default combination of fields (2nd, 3rd
and 4th in your file). But this is only a sample. You can be
more specific based on your needs. For example, if you do not
want two records with the same address, you can select the
address field. <INS> to add the field(s) you want to check for
duplicates.
You can also opt for your B&B System to automatically mark all
duplicate records for deletion. But it is suggested that you
print a report of the duplicates BEFORE opting to delete them
automatically. Check the report first for accuracy and then
re-run the process with the automatic deletion feature turned-on.
If there are several records you prefer NOT to delete, note which
ones on the report, process the automatic deletions, then go back
and Recall them from deletion status individually in the Edit
mode NOTE: Records marked for deletion have a small "diamond" on
the left. You also have the option of assuming that the newest
record is the "good" record, which reviews the file in reverse
order (Last record=Good record).
TIP: You can add (<INS>ert) a new set of fields to check for
duplicates such as: COMPANY and LASTNAME. If YOU WANT duplicates
OF THE SAME COMPANY WHEN THE LASTNAMES ARE DIFFERENT, this
process is ok because BOTH company and lastname fields will need
to match in order to be considered a duplicate. If you don't
want duplicates for one company, but still want the company name
and lastname to appear on the report, this is what you can do:
Pressing <E> for the <E>dit option will allow you to change three
items, the HEADING DEFINITION (top line of the report), the
PRINT DEFINITION (fields actually printed), and the fields to
check for DUPLICATION (also the fields displayed on your screen).
Just remove the reference to LASTNAME in the DUPLICATION listing
of fields.
If the DUPLICATION line is COMPANY+LASTNAME, you can edit the
line to appear as follows:COMPANY. Only Company values will be
checked for duplication, while company & lastnames are printed on
the report.
B&B DOALL User's Guide 30
PROPER CASE
Also, if you cannot rely on the data being in Proper Case, then
you may want to consider changing COMPANY to UPPER(COMPANY).
This will force the comparison to be based totally on upper case.
INDEX PREPARATION
If you have a large data file, please remember that a new index
file is required to be built each time for ALL SOUNDEX type
comparisons, ALL EXACT matches that involve multiple fields, and
any matches using UPPER().
B&B DOALL User's Guide 31
IMPORT/EXPORT
---------------
B&B Systems can READ or WRITE files from/for use by, other
sources (mainframe computer, 1-2-3, word processors, mail-merge,
Dbase, R-Base, list vendors, etc.).
Normally, when exporting or importing, you will be using the
default Master Data file. But you will see that in some of the
"pop-up" options where you can access other data files for lookup
purposes, you can export or import to other .dbf files. For
example, you can import records into the Zip.dbf file. If you
only enter records for Illinois, you could Import a file of
Illinois Zip/City/State data into your Zip.dbf file. You would
be wasting a lot of Disk Space if you imported all 43,000 USA zip
codes. If you expand into Iowa, import Iowa zip codes at a later
date.
IMPORT
------
B&B Systems will import many types of data, word processing and
spreadsheet files, in addition to the standard ASCII files.
Purchased Lists
---------------
If you purchase data for your System from a vendor, ask if they
will supply the data in one of the formats (such as ASCII comma
delimited) that B&B Systems can Import, and if ASCII, if they
will supply the data in the order (which field comes 1st, 2nd,
etc.) shown in the structure of the .dbf file in the Appendix.
If you want to see an example of how the Import file should
appear, Export a file from your current file and name it 'TEST'.
Compare it with the new import file for similar structure. If
importing .DBF type files, order is not important, but field
names should match.
TIP: If you import files regularly and your master file has an
Add Date, unless you add it to the import file first, is normally
missing. You can use Search/Replace to enter the Add Date by
Flexi-Selecting all records with a blank Add Date, then
Search/Replace with current date. When adding records in Add
Mode, Add Date is assumed to be today's date.
EXPORT
------
There are several additional options available before exporting
your file. You will be presented with the FLEXI-SORT option to
allow you to sort your file in a specific order. The
FLEXI-SELECT option will allow you to select only specific
records for your export file.
And lastly, A VERY POWERFUL OPTION. You will be asked if you
would like to change the 1) sequence of your output fields AND/OR
2) Which fields are included. For example, you may prefer your
file to have the Company Name in front of the Last Name. OR, you
may not wish to include Sales or Added-to-file-date field in your
export file. This option may be necessary if the system using
B&B DOALL User's Guide 32
this file requires a certain sequence of fields.
If you select to export an ASCII Comma Delimited field, you can
also opt to select a different delimiter (the character that
separates each field) than a comma. For example, you may use a
software package that needs the '@' character to mark the
beginning and ending of fields.
ASCII files
-----------
There are two common types of ASCII file formats: COMMA DELIMITED
and SDF(Standard Data Format). ASCII refers to the fact that
ONLY Normal ASCII characters (numbers or letters of the alphabet,
upper or lower case, and a limited number of special codes)
appear in the file. There are no special control or binary
codes. In both types of ASCII files, every record is a separate
line, with records separated by a line feed ASCII(10) and
carriage return ASCII(13). The remaining difference between
these two types of files is how the data appears on each line.
You can test if a file is ASCII by reviewing the file on your
screen. At the DOS prompt, enter C:>TYPE FILENAME.TXT. If every
character is legible (no special characters, unusual spacing, no
beeps from your computer), then it is probably an ASCII file.
Most other programs, such as Lotus 1-2-3, R-Base, Symphony, and
most MailMerge programs can use, or produce, a file in at least
one of these formats.
COMMA DELIMITED files contain commas to separate fields. Many
Word Processing and Data Base Management software handle this
type of file. Commonly double quotes (") are used to enclose
character type fields. Numeric fields are left alone. Also,
numeric fields do not contain commas to delineate thousands.
This transfer method saves space, and is fine if the number, AND
the order of the fields is the same in the FROM and TO systems.
STANDARD DATA FORMAT files contain fields that start in specific
positions no matter how much data the field actually contains
(common for Spreadsheet programs). Field 1 starts in Column 1
and field 2 starts in Column 12(?) even if field 1 is blank.
This method is necessary if you need to change the length of
fields, OR add/delete fields because the FROM or TO system have
differing file structures. The reason is: since all data is in
columns, you can use a word processor to shorten/eliminate/add
columns.
For example, if you require that the export file ADDRESS be 20
characters long, instead of 25, you need to use your word
processor to DELETE a 'Block' of text 5 columns wide. You will
need to become familiar with 'Blocking' and setting the
'Blocking' mode to columnar (ie. the text you block will appear
to be vertical columns, and excludes text to the left and right
B&B DOALL User's Guide 33
of your 'Blocking' markers). In Wordstar, set this mode with
Ctrl-K-N.
If, in the prior example, you need an address 30 characters long,
you would INSERT a 'Block' of blank text 5 characters wide at the
25th position of the address.
COMMA DELIMITED file example
-----------------------------------------------------------------
| Smith, Joe, 123 Main ST, New York, NY, 10000, etc. |
| Jones, William, 666 E St, Elmhurst, IL, 60011, etc. |
-----------------------------------------------------------------
STANDARD DATA FORMAT file example
-----------------------------------------------------------------
| Smith Joe 123 Main ST New York NY 10000,etc. |
| Jones William 666 E St Elmhurst IL 60011,etc. |
-----------------------------------------------------------------
IMPORT/EXPORT FROM DATA BASES, INCLUDING SQL
Most software packages support the writing and reading of
standard ASCII files, and SQL data bases are no exception. Using
Oracle SQL version 5.1 as an example, ASCII files can be
exported, or written from SQL by using Oracle's SPOOL <filename>
command; issuing SELECT <field names,...> statement; and SPOOL
OFF after writing the file. Don't forget the YYYYMMDD ASCII date
format. To read an ASCII file into SQL, use Oracle's ODL
utility. By writing a copy of B&B's records, then reading them
into SQL (and vice versa), you can transfer data back and forth.
If the number of fields are different on the data bases (ie. you
need to 'write' a home AND business phone number but only have
one phone number, set up a 'blank' field with a length of 1
character. Then when defining the fields to be written, enter
the name for the 'blank' field wherever you need a field, but
don't have one). Also, when any data is changed, re-index
(housekeeping) your B&B records before using them.
FILE UPDATING
REMOTE OFFICES vs CENTRAL OFFICES
=================================
With DOALL, you also have some extra options that allow you to
easily transfer data back and forth between REMOTE OFFICES or
sales personnel and CENTRAL OFFICES. This assumes that the data
structures in both locations have the same field names.
Here is how you can use these options. First of all, to use
these options you will need to select a field, like OFFICE or
SALESREP or REP, that uniquely identifies the ownership of each
record.
REMOTE
------
Copy Option -
Let's say the CENTRAL OFFICE wants updated information on your
B&B DOALL User's Guide 34
contacts or sales results. If you are using DOALL remotely, you
can make a copy of your local file to send or transmit to the
central office. You will be asked for the OFFICE or REP code,
and all records with that local code will be copied to a file.
For example, if the REP field is selected and the REP code is ML
(Michael Lewis), all records with ML in the REP field will be
copied to a file called ML.REP.
Merge Option -
In addition, if your CENTRAL OFFICE has added some accounts, or
has updated information for you, you can Merge that file into
your remote file. When they send you a new ML.REP file, select
the Merge function to replace all the records having ML in the
REP field with the new ML.REP file from the CENTRAL OFFICE.
Note: this process will delete all existing records with ML in
the REP field, and add the records in ML.REP, so make sure that
the ML.REP file from the office is the "latest" information (say,
after you uploaded a file the day before, and they made changes
to it).
CENTRAL OFFICE
--------------
Copy Option -
You have the option of making a copy of the "ML" records from the
CENTRAL file. The CENTRAL office personnel can make it
themselves, or, if the Michael Lewis is allowed access to the
central file over phone lines, Michael can produce the file and
download it himself.
Merge Option -
The CENTRAL OFFICE may have a procedure where all Sales Reps
submit copies of their files every month. If you collect these
files, say ML.REP, SF.REP and RT.REP, have them put in one
directory. DOALL will sense the existence of multiple .REP files
and will merge the data in each of these files by deleting all
records with the ML REP code, then adding the ML.REP file, then
deleting the SF records, etc. The .REP files are then deleted
automatically.
Note: make sure that there are no duplicate REP VALUES, like
Michael Lewis and Mickey Lisbon.
MAINTENANCE
===========
DELETING RECORDS, PACKING, and REINDEXING issues
------------------------------------------------
When you delete records (usually with CTRL-T in Browse), they are
"marked" as deleted. They are not physically removed until you
select the "PACK" option in file maintenance. Until you Pack,
you can always "undelete" records with another CTRL-T. When you
have records that appear in "unsorted" order, it can usually mean
that the .CDX index file is bad. If you erase your
<filename>.CDX file, a new .CDX file will be created for you
automatically when you start your system. On a network, be aware
that DOALL will not allow access to the file for packing or
reindexing unless you are the only one using it.
B&B DOALL User's Guide 35
DELETE or UNDELETE GROUPS OF RECORDS
------------------------------------
This is a convenient method of marking large groups of records as
having either deleted or undeleted status, instead of doing so
individually in the browse screen. Marking records for deletion
does not permanently remove them. They will be permanently
removed when the file is packed.
You will be provided with the Flexi-Select screen. From this
selection screen you can select field(s) AND enter the values for
each field that you are interested in. Records matching those
values will be selected (For more information, see Flexi-Select)
To review these records BEFORE deleting them, select Browse and
the same record selection in Flexi-Select. Browsing them gives
you the opportunity to confirm this process of marking/unmarking
records for deletion.
ADD/DELETE FIELDS
=================
If you decide to add or subtract fields in File Maintenance -
Modify Structure, you will be asked if you want to delete the
file:????SORT.MEM & ????????.CDX. The ???? refers to the 1st 4
characters of the .DBF filename. A new .CDX file will be created
for you, and you may need to re-define any special sorts you had
added. Also, some Flexi-Select options may no longer be relevant
if you delete fields that were once used in the definition.
BROWSE SCREEN TIPS
==================
SPLIT BROWSE SCREEN TIP: When in a BROWSE screen, you can "split"
the screen into two sections. Let's say you want the last name
or manufacturer name to appear "fixed" in one browse screen on
the left, so that you can <TAB> through the rest of the fields on
the right. How? Use your mouse to the little double arrow at the
bottom and move to the right to make your partition.
SPLIT BROWSE SCREEN EXAMPLE:
(stays fixed) (While you move thru fields)
----------------- ----------------------------------
COMPANY <--- LAST NAME | PHONE ---->
----------------- ----------------------------------
ABC Company Jim Jones 555-2222
XYZ Company John Smith 333-2222
123 Company Jane Doe 111-2222
----------------- ----------------------------------
SHORTEN FIELDS BROWSE SCREEN TIP: Also, when in any BROWSE
screen, you can shorten the width of displayed fields. If your
CITY field is 30 characters long, and most of the cities are less
B&B DOALL User's Guide 36
than 20, you can display just 20 so that more fields will fit on
your screen (This will not effect how much data is stored in the
field, only how much is displayed). HOW? Use your mouse to the
little divider line between field names (at the top of the
column) and drag the divider left.
MOVE FIELDS BROWSE SCREEN TIP: Also, when in a BROWSE screen, you
can move a field to a different location. You can move ZIP to
the far left. HOW? Use your mouse to the field name (at the top
of the column) and drag the field name left or right.
PRIOR TO PRINT JOBS
-------------------
Prior to sending most jobs to the printer, you will be asked if
you would like to send control codes which will change
configuration of the printer.
<YES> will send some basic printer codes, like, lines per page,
line per inch, etc. You will then be able to <PRINT> use the
default printer, or a different printer if you pick <SELECT>. If
you <SELECT> a different printer, you'll see an option to ADD a
printer to the list of selected printers. If you <ENTER> or
mouse click on this option, you will see a list of printers.
Enter a "Y" in the field SELECTED to add a printer to the list.
You can also define which printer is the default printer, by
entering "Y" in the DEFAULT field.
<NO> will not send control codes and will use the current state
of the printer.
<CUSTOM> will give you more control, or if you need to use a
PostScript printer.
Postscript Printers - set up
----------------------------
To set up a Postscript printer, there are several steps required.
ONE TIME
1. Select the option to "ADD a printer" to the list of selected
printers.
2. Find "POSTSCRIPT" in the list of printers, and put a "Y" in
the field SELECTED. You can also include a "Y" in the DEFAULT
field if you desire this printer to be the default.
3. The list of selected printers will be re-displayed. <ENTER> or
mouse click on it.
4. You will be presented with a custom "Printer Driver Setup"
screen.
5. Select <NEW> and use arrows to find the Postscript printer in
the list of printers one more time. Select it and <Enter>.
6. Enter a setup name like: POSTSCRIPT 10th FLOOR.
7. Confirm that proper font, point size, etc. and choose <OK>.
8. Arrow down to the newly added Postscript driver in the list of
drivers and <ENTER> on <SET DEFAULT>.
TO SEND CODES
B&B DOALL User's Guide 37
9. Choose <SET> to send the control codes to the printer.
PRINTER MAINTENANCE MENU OPTION
-------------------------------
You can use the EDIT option to actually change the control codes
that are sent to your printer. For example, if you have a
printer that is not in the list of selected printers, and you
want to change the values in one of the printer records
(P_CODES.DBF), see your printer manual for the control codes.
They are usually shown as decimal codes. If you want to change
the codes used to reset your printer, enter the decimal codes as
CHR(##) CHR(##) CHR(##). The system will convert the CHR() value
for you.
Note: you may notice that some of these codes may have curly
brackets around a number symbol:{#}. This indicates that the
code is not quite set up yet. For example, there is no way we
know how long your page length needs to be defined, so under page
length you may see these brackets. To have the page length
feature used successfully, you need to replace the # and curly
brackets with the number is decimal code. 62 would be
CHR(54)CHR(50).
You can also sent the setup codes to your printer.
You can use this option to force your printer into various print
modes, including setting up your printer for other systems, in
addition to your B&B systems. Once your printer has received a
Control Code, it remains in effect until the printer is turned
off, or new Codes are sent.
SETUP OPTIONS
-------------
TOGGLE SCREEN DISPLAY allows you to put more lines of data on the
screen, assuming your monitor and video card will support 43
lines on an EGA system, and 50 lines on a VGA system. Handy to
see more data when in the Browse screen.
CHANGE MONITOR DISPLAY/COLOR type allows selection of monochrome,
color, or laptop type video displays. You can use this option to
select a color combination that makes your screen easiest to use.
You can select the Standard defaults for B&B Systems, or
Customize your own colors, or default to the FoxPro defaults.
These color definitions are saved in the file COLORDEF.DBF
SELECT FIELD TO CHECK for DUPLICATES allows you to select say,
lastname, so that when adding records, if a record with a
similar last name appears, a list of the similar records will be
displayed for you. In addition, you will be asked which sort
should be the default sort when duplicates are found. For
example, you may wish to check LASTNAME for duplicates, but when
a duplicate appears, you may want more than just a lastname sort.
B&B DOALL User's Guide 38
You may want LASTNAME and FIRSTNAME, OR you may want LASTNAME and
COMPANY.
MODIFY ADD SCREEN. An add screen is made for you when you first
add a record. This file name is <dbf file name>.PRG. If you
compile this file with FOXPRO, you can have extensive data
control, like automatic popup fields for blank entries, allowing
only a range of values (1 thru 1,000), allowing only numeric
values (PICT '@9'), etc. If you have foxpro, run foxprol and
select Compile under the Program menu selection. For extended
memory versions of B&B Systems, run foxprolx instead.
MAKE/EDIT a .REP DATA FILE USED WHEN ADDING RECORDS. Whenever
you add records, if a .dbf type file, with a .REP file extension
exists, values in this file will copied into fields with the same
name in your add screen. If you add "IL" (Illinois) to the state
field in this .REP file, whenever you add a record, the state
field in the new record will contain "IL" automatically.
CHANGE MEMO FIELD DISPLAY in BROWSE. If your data file has a
MEMO type field, you can elect to have the contents of this memo
field display automatically when you move to different records
while in the Browse mode. You can also elect to use the last 5
lines on the screen for the remarks, or the last 10 lines on the
screen.
If you have MEMO TYPE FIELDS, you can import files directly into
memo fields without re-typing. Select the MEMO option from the
top menu in the Browse screen and you can import any file of
notes, letters, any reference material. Conversely, if you have
data in a memo field, you can export the information to a
separate file.
BROWSE SCREEN TIPS
==================
SPLIT BROWSE SCREEN TIP: When in a BROWSE screen, you can "split"
the screen into two sections. Let's say you want the last name
or manufacturer name to appear "fixed" in one browse screen on
the left, so that you can <TAB> through the rest of the fields on
the right. How? Use your mouse to the little double arrow at the
bottom and move to the right to make your partition.
SPLIT BROWSE SCREEN EXAMPLE:
(stays fixed) (While you move thru fields)
----------------- ----------------------------------
COMPANY <--- LAST NAME | PHONE ---->
----------------- ----------------------------------
ABC Company Jim Jones 555-2222
XYZ Company John Smith 333-2222
123 Company Jane Doe 111-2222
----------------- ----------------------------------
B&B DOALL User's Guide 39
SHORTEN FIELDS BROWSE SCREEN TIP: Also, when in any BROWSE
screen, you can shorten the width of displayed fields. If your
CITY field is 30 characters long, and most of the cities are less
than 20, you can display just 20 so that more fields will fit on
your screen (This will not effect how much data is stored in the
field, only how much is displayed). HOW? Use your mouse to the
little divider line between field names (at the top of the
column) and drag the divider left.
MOVE FIELDS BROWSE SCREEN TIP: Also, when in a BROWSE screen, you
can move a field to a different location. You can move ZIP to
the far left. HOW? Use your mouse to the field name (at the top
of the column) and drag the field name left or right.
OTHER OPTIONS
-------------
PRINTER TRAY CONTROL - If you have a dual tray printer, you can
define printer control codes that will select the top tray for
page 1 of letters (letterhead) and select the bottom tray for
subsequent letter pages.
CALLBACK DATE SPAN - If you have a callback date field in your
file, and if you have ANY callback dates pending (in the future),
you will be asked if you would like to review these records in a
browse screen. If you don't want to see the callbacks six months
from now, and only want to see those within the next two weeks,
you can enter 14 days here.
HOW TO USE DOALL WITH SALES LEADS
---------------------------------
B&B DOALL can be your Marketing Mailings Manager. It can keep
track of all of your customer data now kept in separate files or
logs. Report on Sales Leads cultivated as a result of specific
promotions (use a "Source" code field), or report on Leads with
the highest sales potential and likelihood of closing (use a
"Qualified" code field). Track time and dollars spent
cultivating sales, etc. This manual will give you some hints on
how to collect your sales lead information and if you are already
collecting it in a .dbf type file, how to access that file, or
even "import" your separate files into one file we'll call
SALELEAD.
DON'T SEPARATE FILES....PICK A FIELD, ANY FIELD
It pays to look ahead on how you expect to use your file. If you
have one master file, you can always 'dissect' (not physically)
your file into sub-files, and thus use one file for multiple
purposes. With DOALL, you can use Flexi-Select to just pick
records where interest='BC' (your Bridge Club), and just
concentrate on those.
Maybe you need to add a field to handle 'I' Industrial or 'S'
Special Handling accounts. For large volume Mailers, any two
character field can be used to contain the carrier route
information.
B&B DOALL User's Guide 40
It is not recommended that you have separate files for separate
purposes. Use values in fields to distinguish record types.
It is not recommended for this reason: Having all records in one
file will be an advantage when it comes to maintenance. When you
edit a record in one file (address change), a similar record in
another file will become outdated. Instead, all records, should
remain in one main file, with codes indicating uses.
DEVELOPING and PROCESSING SALES LEADS
Here is a example of the Postcard method to develop and process
Sales Leads. This postcard is designed to fit many sales
activities, such as handouts at seminars & expositions, mailing
stuffers, and for recording office or field calls. When ready
for processing, plan ahead by designing the format to follow your
add and edit screens (Easier for everyone to input data). Print
them on standard 3.5 x 5.5 postcard stock, with your company name
and address on the front and it becomes an easy-to-return self
mailer for a Sales Lead. Consider having it printed with
Business Reply Mail pre-paid postage, available from the U.S.
Post Office for an annual fee and a per piece handling fee.
(They can still be used as an office form to record leads, you
won't incur postage costs).
SALES LEAD POSTCARD EXAMPLE
+--------------------------------------------------------------+
| ABC Company |
| |
| |
| Name ___________________________ Title ________________ |
| |
| Company ________________________ Phone ________________ |
| |
| Address _____________________ City ________ ST ___ Zip____ |
| |
| Contact me regarding: |
| [ ] MODEL#1 Airplanes [ ] MODEL#2 Planes |
| [ ] #245 parachutes [ ] etc. |
| |
| |
| Comments:_____________________________________________ |
| _____________________________________________ |
| |
+--------------------------------------------------------------+
(REVERSE SIDE should be self-addressed to ABC Company)
Set up the Product Interest check-off boxes to resemble your
Product/Services. Once returned, you can easily enter data from
these cards.
ANALYZE REASONS FOR LOST SALES
Analyze why you lose sales. Use a Miscellaneous code to assign a
reason why a sale was lost (ie. Q=perceived as being lower in
B&B DOALL User's Guide 41
Quality, P=higher in Price, etc.). Also indicate in a field the
potential sale size, Then you can later review the impact of
lost sales by using Flexi-Select to select records with any of
these lost sales codes. Sort by this code, and print this misc.
code plus any potential sales field. The frequency and impact of
each code will tell a story.
SOURCE - Measure Marketing Program Effectiveness
A Source field can be added for tracking the origin of each Sales
Lead. Indicate the type of media (ie. NE=Newspapers, RA=Radio)
that produced the Lead, or pinpoint Leads developed as the result
of specific marketing programs. For example, Promotions for
program #1 can be coded 'P1', Program #2, 'P2', etc., Cold Calls
'C1', or Direct Mail 'D1'. The potential combinations are
numerous. You can even use codes that indicate the timing of
your promotion, by using month & year in your code. Your fall
and spring promotions can then be easily 'picked out'.
Summarizing sales, expenses and other data could provide an
indicator of where your marketing dollars are being spent, which
ones develop the most Leads (and the ones with the most
potential) and possibly where your marketing dollars should
spent.
B&B DOALL User's Guide 42
GENERAL COMPUTER OPERATIONS
---------------------------
BACKUP
------
Make BACKUP copies often (at least of your *.dbf files). If you
have many transactions per day, you should backup daily, if not
twice daily. You should also have multiple backup copies so that
you have at least one backup that is less than one day old, one
a week old, one a month old, etc.
Backup hardware has become available in many different formats.
External units can be moved around to perform backup on multiple
PC's.
LETTERS VS. LABELS
------------------
If you are looking for options other than affixing labels to
envelopes, B&B Systems urges you to use personalized letters
which fit into window envelopes eliminating matching labels with
letters, allows professional customized letters, and reduces
manpower for mailings.
CUSTOMIZING SERVICE
-------------------
If you wish different fields on your screen, or would like some
other modification made to your B&B System, we will be happy to
discuss the cost of your desired changes.
EXISTING FILE CONVERSION SERVICE
--------------------------------
If you currently have a file of mailing records (from a 'list'
vendor, 1-2-3 files, ASCII files, etc.), but do not know how to
convert them to the B&B format/structure (see Appendix), B&B will
convert this file for you at ten cents per name. Send the file
electronically to B&B's electronic Bulletin Board, P.C. Manager,
or send on an IBM 5 1/4" 360K floppy disk/or 3-1/2" 1.4m disk to
B&B Systems. The approximate time required is 2 weeks.
YELLOW PAGES NAMES/ADDRESSES by ZIP CODE or SIC Code
----------------------------------------------------
B&B Systems can provide you with Company Name - Address - City -
State - Zip - SIC Code data from the Yellow Pages for any ZIP
CODE or STATE or SIC (Standard Industrial Code) that you supply
to us. The costs vary, depending on the quantity desired. Leave
a message on B&B's Bulletin Board, PC MANAGER, requesting a quote
for desired zip codes and types of businesses. After a deposit,
the completed file can then be mailed to you on a floppy, or made
available to you on the Bulletin Board.
B&B DOALL User's Guide 43
LABELING Machines
-----------------
Machines are available to affix self adhesive labels onto your
mailing pieces. Some manufacturers:Novatec of Gladwyne, PA;
Master Addresser of Minneapolis, MN.
TEXT EDITING - CUT & PASTE
--------------------------
In some B&B systems you will be given the opportunity to edit a
file such as a report or letter prior to printing. You can do
some simple cut and pasting using FoxPro commands. To 'block' or
highlight text, use SHIFT and the ARROW KEYS. After highlighting,
you can cut text with Ctrl-X, to copy the text, use Ctrl-C and to
Paste the text you've highlighted, use Ctrl-V.
Other Key Combinations
======================
TAB - moves field by field to the right in Browse screens.
SHIFT-TAB - moves field by field to the left.
CTRL-W - will save editing screens
CTRL-Q - will not save editing screens
CTRL-Right Arrow - move one word to the right
CTRL-Left Arrow - move one word to the left
B&B DOALL User's Guide 44
ERRORS -
TROUBLESHOOTING
---------------
Before calling for technical support, many problems can be
resolved by: 1. Ensuring that you have all of the files listed in
this documentation. 2. Checking your config.sys file for the
proper Buffers and Files statements.
ERROR: Cannot create program file - system does not load
FIX: Check CONFIG.FP file carefully. It probably contains a
directory that does not exist.
Q. My data appears unordered. When I select the LASTNAME sort,
the records are not sorted by lastname.
A. The sorts are all stored in a multiple index file called
<filename>.CDX. This file is created upon startup if it is
missing. If you accessed your data file without the .CDX being
active, or somehow had corruption on your disk, the .CDX will not
point to the right records. Just ERASE the <filename>.CDX file
and a new one will be created.
Q. WHEN I EDIT MY PRINT CODES FILE, I WANT TO DIRECT MY PRINTED
OUTPUT TO A QUEUE or SERVER NAME, HOW DO I DO IT?
A. In the field that defines the printer port, use:
\S=<servername> or \Q=<queue> with no quotation marks around the
queue or server name.
Q. WHEN PRINTING MY REPORTS, THE DATA APPEARS TO CONTAIN
DUPLICATES OF ONE RECORD.
A. Check your report file (.FRX) to make sure that the individual
fields do not contain a file alias for each field, such as
myfile.lastname. Eliminate alias, or file names, from any field
names.
B&B DOALL User's Guide 45
HELP. I'M STUCK
----------------
ANY PROGRAM CAN CORRUPT FILES - HOW TO AVOID IT
-----------------------------------------------
If you are running a system and you get into a situation that
you'd like to exit from, some applications allow you to enter the
<ESC> key. In other systems. you may need to wait for the
process to end. If your system allows the use of the ESC key,
and B&B does, use it, the ESC key will not alter or change the
files. BUT, Be patient. Depending on what the system was doing,
it may take 1 second or 1 minute. BUT PLEASE, IN ALMOST ALL
CASES, AVOID RE-BOOTING (cold or warm boots). If you re-boot
your computer BEFORE your system finishes the process it is
currently working on, you could corrupt your file(s). The
computer may have been READING data, but does not now know where
to WRITE it. THIS IS ONE OF THE MAJOR CAUSES OF CORRUPTED FILES.
This is another good reason for frequent back-ups.
If you are not sure if your file has become corrupted, print a
report that lists the entire file. If any of the data appears
missing or switched, your file is probably corrupted. If binary,
or strange looking characters appear, your file is corrupted. If
you're not sure, first make a new index file by erasing the .CDX
file (a new .CDX file will be created, with a sort definition for
EACH field in the data file). Re-run your report, and if that
does not fix the 'order' of your data, AND IF YOU ARE NOT IN A
NETWORK, run the DOS CHKDSK program with the '/f' (fix lost
clusters option), C:DOS>CHKDSK C:/f. If corruption did occur,
DOS will write the corrupted data in separate files called
FILE0001.CHK, 0002, etc. Since this data has now been separated
from your .dbf or other files, you should copy your .dbf files
from your backup. If your B&B System does not boot properly, you
may need to copy your system files from back-up also.
HINT: CHKDSK is a good command to insert in your autoexec.bat
file, so that your hard drive is checked every time you turn
your computer on. This takes 10 to 20 seconds longer to boot,
but it will avoid the continued corruption of a fragmented disk.
DO NOT RUN CHKDSK ON A NOVELL NETWARE FORMATTED disk, but you can
run CHKDSK prior to loading LAN software on a peer-to-peer type
network drive.
DEVELOPERS/CONSULTANTS
======================
Because B&B Doall allows flexibility in accessing any type of
.dbf file, developers can customize systems for their users
through the use of the custom.prg program and by using the setup
parameters. This reduces your development time and gives
customers faster/economical service.
FILES
=====
FOXPRO.ESO, .ESL, and FOXR are the FoxPro2 runtime files
B&B DOALL User's Guide 46
(FOXPROX.ESL is available for higher performance machines (386 or
above) with Expanded Memory, giving greater performance. Need to
get Expanded versions of other .FXP files too on B&B's BBS).
DOALL.FXP or .EXE, P.FXP and PDRIVER.FXP are your B&B DOALL
System files.
P_CODES.DBF, .CDX are the files containing printer control codes
<DataBaseName>.CDX is the file containing all of your sorting
information. And, starting with version 1.5, if you define a new
sort, it will not have to be re-created each time you want to use
it. All custom sorts added to Flexi-Sort are maintained
continuously when you add and delete records.
CONFIG.FP is FoxPro's configuration file. If you have a Foxpro
manual, refer to it for customization features.
CUSTOM.PRG - Sample file that is executed whenever DOALL is
started. You can use Xbase code to write any startup program
you'd like, then compile it with FoxPro to make an .FXP file.
PRODUCT.DBF - Sample data base file that can be filled with
product information for instant access. It is called by using
<CTRL-F2> as defined in the coding in custom.prg.
HELPFILE.DBF - Sample help file customizable by user.
.CDX files - Index or Sort file created by DOALL. Initially,
there is one index for each field in the data file. Newly
defined sorts are added to this file.
.LBX/.LBT - sample Label format files.
.FRX/.FRT - sample Report format files.
ZIP.DBF - sample zip file accessed as a lookup file <F2> when in
the zip code field.
STATE.DBF - see zip.dbf
REP.DBF - use for a code for Sales Reps or Local Offices.
DISTRIBU.DBF - use for a code for Distributors.
Environmental Variables:
SET ASCEDESC=ASCENDING or DESCENDING, Depending on default index
order desired.
SAMPLES of filenames (for a data file called "SAMP"LE.DBF):
-----------------------------------------------------------
SAMP SORT.MEM - Flexi-Sort definitions
SAMP SELE.MEM - Flexi-Select definitions.
SAMP RPT.MEM - Flexi-Report definitions.
SAMP SPC.MEM - Field Name/Index used when Adding-Duplicate check.
SAMP QLBL.MEM - Set up values for Quick Label
SAMP EXIM.MEM - Import/Export definitions
SAMP FIND.MEM - Default Field used in Find/Replace in Browse
SAMP ZRPT.MEM - Print Setup values for zip code group report.
SAMP FREP.MEM - Print Setup values for Flexi-Report.
SAMP SETP.MEM - Print Setup values when sending setup codes.
SAMP REPO.MEM - Print Setup values for FoxPro Reports.
B&B DOALL User's Guide 47
SAMP LABE.MEM - Print Setup values for Labels.
SAMP LTRS.MEM - Print Setup values for Letters.
SAMP SREP.MEM - contains Field defined as Rep Code for sending
uploads to central office
SAMP GREP.MEM - contains Field defined as Rep Code and last
directory location for getting downloads from central office.
SAMPLE.DBF/.FPT - Name of Sample.dbf and memo file
SAMPLE.FXP - Name of Sample.prg after compilation
SAMPLE.LBX/.LBT - Label form file and memo file
SAMPLE.FRX/.FRT - Report form file and memo file
B&B DOALL User's Guide 48
--------
UPGRADES
--------
The most recent demo versions of B&B Systems programs are on
Compuserve (GO IBMAPP), EXECPC, or B&B's own Bulletin Board, PC
MANAGER, (414) 548-9034. [Settings:8/N/1, 8 data bits, No
Parity,1 Stop bit]. B&B's Bulletin Board supplies registered
owners with the latest versions of unrestricted B&B Systems
without waiting for mailed copies.
Occasionally, new upgraded files like printer codes or letter
files become available. They normally have "UPGR" incorporated
into the file name, and can be copied onto the regular directory.
When your system is started, you will be asked if you want to
upgrade this new file.
--------------------
ORDERING INFORMATION
--------------------
If ordering by check, please allow at least 2 weeks. If you
prefer, B&B Systems can supply your program via modem provided
you register on our bulletin board. This has two advantages:
1. upgrades of new unlimited versions become available
immediately. 2. If paying by Visa/Master Charge, you can get your
system faster, as soon as 1/2 hour.
Note: If your system is licensed on an annual
basis, and you wish an upgrade, all you need
to do is:
1. Contact B&B systems. Find out if we have
an upgrade that interests you (Technical
support subscribers receive upgrade
notification automatically).
2. If you wish the free upgrade, we will put
a special file on the Bulletin Board System
for you to download via modem at your leisure
(Commonly using your company name for the
filename). If you cannot download your
upgrade and require us to send a disk, there
is a $25 handling fee.
If you desire that certain features be included in newer
versions, contact us to see if the enhancements have already been
included in new versions, or if your special needs can be
incorporated into future versions.
You can order by calling B&B Systems direct (414-544-5988), or
call our Bulletin Board, P.C. Manager (414-548-9034) and <A>CCESS
the ORDER system from the Main Menu. You will be asked for
shipping information and your credit card data. After your card
is verified, you will be authorized to download registered
versions, usually .zip or .exe files that end in .ziu or .exu
(unlimited).
B&B DOALL User's Guide 49
If you order by mail, and plan to download electronically, you
will be registered under the first and last name and password you
supply on the order form in this file. It is recommended that
you change your password after accessing B&B System's bulletin
board the first time.
If you ordered from a dealer and want to be eligible for
upgrades, sign on to P.C. Manager, and leave a message that you
would like a security level allowing upgrade downloads, and which
dealer you purchased your system from. Once the purchase has
been validated, your security level will be upgraded.
We try to keep our software costs low. Our policies are simple.
1. Since no software is error-free, we will fix any bugs. 2. We
will add improvements requested by users, and do it free if it
has value to other users. 3. We cannot afford to train users how
to run computers, use DOS commands, or even how to run their B&B
Systems unless they register for annual technical support
services.
If you've forgotten to register a DEMO and need to access your
system immediately, we can sometimes supply an emergency access
code over the phone with a credit card order.
If you plan on installing B&B systems on MORE than one machine,
consider a SITE LICENSE. You can move a registered system to a
different machine, but making copies is not only illegal, but
more importantly, unethical. A SITE LICENSE allows unlimited use
of NETWORK or STAND-ALONE versions at one location. A CORPORATE
LICENSE allows the same unlimited use, but at multiple locations.
LICENSES are not software purchases. They are licenses to use
software for a specific period of time, normally annually.
OTHER SERVICES: (billable by project or by hour)
CREATE NEW or MODIFY EXISTING B&B SYSTEMS add/edit screens, rpts.
REMOTE LASER LETTER/REPORT PRINTING programs
OPERATE WARRANTY/SALES LEAD CARD FULFILLMENT programs
FILE CONVERSION/CORRUPTION (upload to BBS, download Fixed file)
B&B DOALL User's Guide 50
-------------------
O R D E R F O R M
-------------------
B & B S Y S T E M S
627 Madison P.O. Box 171
Waukesha, Wisconsin 53187
Order/Technical Support: 414-544-5988 BBS: 414-548-9034
DESCRIPTION QUANTITY EACH TOTAL
-------------------------------------------------------------
B&B DOALL System License _____ 250.00 _______
SITE LIC _____ 500.00 _______
CORP LIC _____ 1200.00 _______
Upgrades (50% of price above) _______
ONE YEAR's UNLIMITED Technical Support Phone service
(Annual $ amount same as software cost above) $_______
FILE CONVERSION SERVICE (# records)=_____ x $.10 $_______
Customization Service (screens, etc. - call) $_______
Shipping and Handling:
___ Sign me up on BBS for immediate downloading - $0
Password desired ____________
___ US Postal Service - $0
___ Express Mail $12 $_______
WI 5% Sales Tax $_______
Format:___ 5-1/4" ___ 3-1/2" Total: $_______
Visa/MC Card Number: _____________________ Exp Date:________
Signature: __________________________________________________
Name: _____________________________________________________
Street Address: _____________________________________________
(if PO Box, add street address)
City: ______________________ State: _____ Zip: __________
Bus. Phone: ( ) __________________________
Current Version # _______________ Date:_________________
B&B DOALL User's Guide 51
WARRANTY
--------
DISCLAIMER OF WARRANTY AND LIMITED WARRANTY
The Software and accompanying written materials (including
instructions for use) are provided 'As Is' without warranty of
any kind. Further, B&B Systems does not warrant, guarantee, or
make any representations regarding the use, or the results of the
use, of the Software or written materials in terms of
correctness, accuracy, reliability, currentness, or otherwise.
The entire risk as to the results and performance of the Software
is assumed by you. If the Software or written materials are
defective, you, and not B&B Systems or its dealers, distributors,
agents, or employees, assume the entire cost of all necessary
servicing, repair, or correction.
B&B Systems warrants to the original LICENSEE that 1) the disks
on which the SOFTWARE is recorded is free from defects in
materials and workmanship under normal use and service for a
period of ninety (90) days from the date of delivery as evidenced
by a copy of the receipt. Further, B&B Systems hereby limits the
duration of any implied warranty(ies) on the disk to the
respective period stated above. Some states do not allow
limitations on duration of an implied warranty, so the above
limitation may not apply to you.
B&B Systems' entire liability and your exclusive remedy as to the
disk(s) shall be, at B&B Systems ' option, either a) return of
the purchase price or b) replacement of the disk(s) that does not
meet B&B Systems' Limited Warranty and which is returned to B&B
Systems with a copy of the receipt. If failure of the disk(s)
has resulted from accident, abuse, or misapplication, B&B Systems
shall have no responsibility to replace the disk(s), or refund
the purchase price. Any replacement disk(s) will be warranted
for the remainder of the original warranty period, or thirty (30)
days, whichever is longer.
THE ABOVE ARE THE ONLY WARRANTIES OF ANY KIND, EITHER EXPRESSED
OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, THAT ARE
MADE BY B&B Systems ON THIS B&B Systems PRODUCT. NO WRITTEN OR
ORAL INFORMATION OR ADVICE GIVEN BY B&B Systems, ITS DEALERS,
DISTRIBUTORS, AGENTS, OR EMPLOYEES SHALL CREATE A WARRANTY OR IN
ANY WAY INCREASE THE SCOPE OF THIS WARRANTY, AND YOU MAY NOT RELY
ON ANY SUCH INFORMATION OR ADVICE. THIS WARRANTY GIVES YOU
SPECIFIC LEGAL RIGHTS. YOU MAY HAVE OTHER RIGHTS, WHICH VARY
FROM STATE TO STATE.
NEITHER B&B Systems NOR ANYONE ELSE WHO HAS BEEN INVOLVED IN THE
CREATION, PRODUCTION, OR DELIVERY OF THIS PRODUCT SHALL BE LIABLE
FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL OR INCIDENTAL DAMAGES
(INCLUDING DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS
INTERRUPTION, LOSS OF BUSINESS INFORMATION, AND THE LIKE) ARISING
OUT OF THE USE OF OR INABILITY TO USE SUCH PRODUCT EVEN IF B&B
Systems HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
BECAUSE SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF
LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES , THE ABOVE
B&B DOALL User's Guide 52
LIMITATION MAY NOT APPLY TO YOU.
The SOFTWARE and documentation is provided with RESTRICTED
RIGHTS. Use, duplication, or disclosure is subject to
restrictions as set forth in subdivision (b)(3)(ii) of the Rights
in Technical Data and Computer Software clause at 252.227-7013.
Contractor/Manufacturer is B&B Systems, P.O.Box 171, Waukesha,
Wisconsin 53187.
B&B DOALL User's Guide 53
INDEX
.FRX 17, 18, 44, 46
.PRX 16
ACCURACY 29, 51
ACTDATE1 3, 25, 26
ACTION1 3, 25, 26
ADD 1-3, 7-11, 13-21, 23-25, 28, 29, 31, 32, 34-36, 38-40,
46, 49, 50
ADD SCREEN 8, 14-16, 38
ADDLTR 19-22
ALIAS 18, 44
ALLCODES 20
ASCII 14, 17, 31-33, 42
AUTOEXEC.BAT 5, 45
BACKUP 4, 9, 11, 12, 42, 45
BARCODE 27
BELLRINGER 3, 19
CALLBACK , 2, , 28,
CANADA 14
CENTRAL OFFICE 3, 33, 34, 47
CNG 8
COLOR 2, 7, 8, 37
COLORDEF.DBF 37
CONFIG.FP 5-7, 9, 44, 46
CONFIG.SYS 6, 8, 44
CONVERSION 42, 49, 50
CONVERT 37, 42
CUSTOMIZATION 12, 16, 17, 46, 50
CUT & PASTE 43
Data appears unordered
SORT 44
DEFAULT 6, 9, 13, 14, 27, 29, 31, 36, 37, 46
DOS ENVIRONMENTAL VARIABLES 5
DUPLICATE 14, 18, 29, 34, 37, 46
EDIT SCREEN 16
ENVIRONMENTAL 4, 5, 46
ERROR 4, 5, 7, 44, 49
ERRORS 4, 44
F10 15, 16
F2 LOOKUP 6
FILELOOK 14, 15
FLEXI-REPORT 46
FLEXI-SELECT 10, 11, 16, 25, 26, 28, 29, 31, 35, , 41, 46
FLEXI-SORT 9, 11, 31, 46
FOXUSER.DBF 5
FOXUSER.FPT 5
FUNCTION 2, 11, 13, 14, 19, 34
HELP 2, 4, 9, , 45,
HELPFILE
IMPORT/EXPORT 13, 14, 31, 33, 46
INSTALLATION 4, 5, 27
KEY COMBINATIONS 43
LABELS 2, , 2, 10, 17, 18, 26, 27, 42, 43, 47
LETTERS 2, , 2, 3, 18-27, 32, 38, 39, 42, 47
LOOKUP 2, 6, 12-15, 20, 31, 46
B&B DOALL User's Guide 54
MAINTENANCE 15, 23, 34, 35, 37, 40
MINIMUM MEMORY
Memory, Minimum 6
MODEM 7, 14, 27, 28, 48
NETWORK 4-8, 34, 45, 49
OPERATING 6, 7, 17, 20
PHONE 2, 20, 27, 28, , 29, 33-35, 38, 40, 49, 50
POSTSCRIPT 36
PRINTER CONTROL 39, 46
QUERY 2, 18
QUERY BY EXAMPLE 2
RECALL 29
REP 15, 18, 20-25, 33, 34, 38, 46, 47
REPORTS 2, 3, 10, 17, 18, 22-25, 27, 44, 46
RUNTIME FILES 2, 7, 8, 45
SALES REPS 3, 20-22, 25, 34, 46
SAMPLE 9, 16, 17, 19-23, 27, 29, 46, , 46, 47
SETUP 4, 5, 14, 15, , 18, 23, 28, 36, 37, 45, 46
SITE 49, 50
SPECIAL HANDLING 19, 39
SPEED TIP 11
SQL 2, , 8, 17, 18, 33
STORAGE 6
STRUCTURE 15, 31, 35, 42
TAX 50
TIP 4, 7, 8, 11, 12, 14, 29, 31, 35, 36, 38, 39
TOPIC 2, 28
UTILITY 33
VEHICLE FILE 4
VOLUME 39
WARRANTY 49, 51
WHAT IF I HAVE FOXPRO 18
WINDOWS 4, 7, 8, 17